Linq按日期年月日分组

var query = from t in db.UserBehavior

group t by new

{

time = new { t.CreatedDate.Year, t.CreatedDate.Month, t.CreatedDate.Day }

} into g

select new

{

zip = g.Count(),

ptime = g.Average(p => p.StayTime),

time = g.Key.time.Year + "-" + g.Key.time.Month + "-" + g.Key.time.Day

};

更多内容请点击访问我的新博客