Convert SQL to equivalent LINQ

Question

is there any way i can convert below syntax to LINQ equivalent.

select DateName( month , DateAdd( month , month(cour_date) , 0 ) - 1 ),count(*)
from course
where cour_date>CONVERT(varchar, YEAR(GETDATE())) + '-01' + '-01'
and cour_deleted is null and cour_type='Group'
group by month(cour_date)
order by month(cour_date)

You might have some luck with this tool http://www.sqltolinq.com/ There are several others mentioned [here](http://stackoverflow.com/questions/296972/sql-to-linq-tool) — DOK, Sep 20 '11 at 15:28
How about having a go then showing us what you tried, Stack Overflow is not a code factory. — Kev, Sep 20 '11 at 20:09

score 1 · Accepted Answer · edited Sep 20 '11 at 17:09

You can use something like this:

var query = from c in course 
            where c.cour_date > DateTime.Parse("2011-01-01") 
                 && c.cour_deleted == null && c.cour_type.Equals("Group") 
            orderby c.cour_date 
            group c by c.cour_date.Month

For each IGrouping<DateTime, course> in the query you have the Count value, and you can also format the DateTime value of cour_date to convert mount in a string.

Convert SQL to equivalent LINQ

1 Answers1