请看看这个SQL语句的 linq如何写
sql:
select month=convert(varchar(6),Addtime,112),monthcount=count(*)
from NewsContent
group by convert(varchar(6),Addtime,112) order by month
sql语句执行结果：
20110522
2011061
2011116
2012031
2012042
[解决办法]
var query=from u in dt.AsEnumerable().Where(c=>c.Field<DateTime?>("ShippedDate")!=(DateTime?)null)
group u by new {mouth=u.Field<DateTime>("ShippedDate").Year.ToString() +u.Field<DateTime>("ShippedDate").Month} into g
select new
{
g.Key,
count= g.Count()
};
[解决办法]
