How to do this in LINQ:
SELECT count(id) as counter, datename(MONTH, PublishDate) + ' ' + datename(YEAR, PublishDate) as date
from BLG_BlogPost
where active=1 group by datename(MONTH, PublishDate) + ' ' + datename(YEAR, PublishDate)
...
Go to the complete details ...