Linq按日期统计查询



1.
 var query=db.A.Where(a=>a.时间>=new DateTime(2005,5,10) && a.时间<=new DateTime(2005,5,12))
.GroupBy(a=>a.时间.Day)
.Select(g=>new{count=g.Count(),sum=g.Sum(x=>x.消费)};

2,

var query=db.A.Where(a=>a.时间.Year==2012)
.GroupBy(a=>a.时间.Month)
.Select(g=>new{count=g.Count(),sum=g.Sum(x=>x.消费)};

nullable的datetime用datetime.GroupBy(a=>a.时间.Value.Day)

3.

具体月份

var query=db.A.Where(a=>a.时间.Year==2012)
.GroupBy(a=>a.时间.Month)
.Select(g=>new{月份=g.Key,count=g.Count(),sum=g.Sum(x=>x.消费)};