我有一个包含datetime字段的表。我想获取按月/年组合分组的结果集,并显示每个月/年中出现的记录数。如何在LINQ中实现?
我最接近的解决方案是在TSQL中:
select substring(mo,charindex(mo,'/'),50) from (
select mo=convert(varchar(2),month(created)) + '/' + convert(varchar(4), year(created))
,qty=count(convert(varchar(2),month(created)) + '/' + convert(varchar(4), year(created)))
from posts
group by convert(varchar(2),month(created)) + '/' + convert(varchar(4), year(created))
) a
order by substring(mo,charindex(mo,'/')+1,50)
但我不会说那会起作用...