8,497
社区成员
发帖
与我相关
我的任务
分享
var query = from data in ds.Tables[0].AsEnumerable()
where data.Field<int>("CallType") == 2
group data by new { t1 = data.Field<int>("Ent_ID"), t2 = data.Field<string>("SDate") } into m
select new
{
Ent_ID = m.Key.t1,
SDate = m.Key.t2,
CallAll = m.Select(x=>x.Field<string>("callcode")).Distintct().Count()
};
var q = from p in db.Products group p by p.CategoryID into g select new { g.Key, NumProducts = g.Count() };