LINQ Query Help!
- by rk1962
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!