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

0 vote269 views1 answer
C# console out restore
C#
9 votes317 views3 answers
Get rigidbody component unity
C#Unity
0 vote293 views1 answer
How to send button name for method in c#
C#
1 vote368 views1 answer
Unity round to x decimals
C#Unity
0 vote305 views1 answer
Unity vector3 to array
C#Unity
3 votes333 views1 answer
How to load the active scene unity
C#Unity
0 vote292 views1 answer
C# alphabetize a list of string
C#
2 votes314 views1 answer
Object spin unity
C#
0 vote299 views1 answer
C# prototype function
C#
0 vote294 views2 answers
C# distinct comparer multiple properties
C#