这个linq语句怎么写
--------------------编程问答--------------------
yuang.Select(x => new { 休假 = xiujia.Where(y => y.id == x.id).Sum(y => y.gongxiu), 其它假 = xiujia.Where(y => y.id == x.id).Sum(y => y.chanjia) })
--------------------编程问答--------------------
--------------------编程问答--------------------
var query= from y in yuang
join x in xiujia on y.id equals x.id into lf
from x in lf.DefaultIfEmpty()
group y by y.name into g
select new {g.Key,gongxiu=g.count(s=>s.gongxiu),chanjia=g.Count(s=>s.chanjia)};
补充:.NET技术 , LINQ