linq group by 多个字段取值以及取出重复的数据

var programmeSame = from p in data.ManagerProgramme
where p.Type==1
orderby p.Date
group p by new { pmmid=p.ManagerId, pmtime=p.time, pmdate=p.Date } into g

where g.Count() >= 2 //加上这句只取出重复的，不加这句取出不重复的

select new {
pmid=g.Key.pmmid,
ptime=g.Key.pmtime,
pdate=g.Key.pmdate
};

foreach (var item in programmeSame)
{
context.Response.Write(item.pmid + ": " + item.ptime + ": " + item.pdate);
}
return;

转载于:https://www.cnblogs.com/KnowEditByW/p/8328934.html