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.消费)};