Linq left join group by

from p in context.ParentTable
join c in context.ChildTable on p.ParentId equals c.ChildParentId into j1
from j2 in j1.DefaultIfEmpty()
group j2 by p.ParentId into grouped
select new { ParentId = grouped.Key, Count = grouped.Count(t=>t.ChildId != null) }

Similar codes

9 votes204 views2 answers
C# calculate difference between two dates in days
C#
1 vote160 views1 answer
C# concant 2 tab
C#
-1 vote204 views1 answer
C# declaration definition
C#
0 vote194 views1 answer
Esc exit winform
C#
0 vote223 views1 answer
Wpf binding ancestor codebehind
C#
46 votes208 views6 answers
C# list
C#
2 votes182 views1 answer
C# check type of object
C#
0 vote211 views2 answers
How to write excel content type while returning from mvc view
C#
1 vote222 views1 answer
Code jokes
C#
19 votes199 views2 answers
Unity RemoveComponent
C#