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