LINQ Query Help!

Question

Can someone hep me converting the following SQL query into LINQ?

select
    convert(varchar(10),date,110) as 'Date',
    max(users) as 'Maximum Number of Users', 
    max(transactions) as 'Maximum Number of Transactions'
from
    stats
where
    datepart(Year, Date) = '2010'
group by
    convert(varchar(10),date,110) 
order by
    convert(varchar(10),date,110)

Thank you in advance!

Answer 1

It's difficult to tell from the limited information you've provided but this might do the job:

var results = from stat in db.Stats
              group stat by stat.Date.Date into statGroup
              orderby statGroup.Key
              select new
              {
                Date = statGroup.Key,
                MaximumNumberOfUsers = statGroup.Max(c => c.Users),
                MaximumNumberOfTransactions = statGroup.Max(c => c.Transactions)
              };