linq 常用查询

1.分组并且查询每组数量

var groupList = from a in examineeList
group a by new
{
a.SN,
a.BeginTime,
a.EndTime
} into b
select new
{
SN = b.Key.SN,
BeginTime = b.Key.BeginTime,
EndTime = b.Key.EndTime,
Total = b.Count()
};

2.分组排序 from n in Model group n by new{n.BeginTime,n.EndTime} into data orderby data.Key.BeginTime select new {beginTime = data.Key.BeginTime,endTime = data.Key.EndTime};