from p in context.ParentTablejoin c in context.ChildTable on p.ParentId equals c.ChildParentId into j1from j2 in j1.DefaultIfEmpty()group j2 by p.ParentId into groupedselect new { ParentId = grouped.Key, Count = grouped.Count(t=>t.ChildId != null) }
from p in context.ParentTablejoin c in context.ChildTable on p.ParentId equals c.ChildParentId into j1from j2 in j1.DefaultIfEmpty()group j2 by p.ParentId into groupedselect new { ParentId = grouped.Key, Count = grouped.Count(t=>t.ChildId != null) }名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
