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
};
更多内容请点击访问我的新博客