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

1 vote341 views1 answer
How To Get The Global Position of a GameObject in a Variable
C#
1 vote298 views1 answer
Making beep voice in c#
C#
2 votes410 views1 answer
How to do a web request unity
C#Unity
1 vote306 views1 answer
Arcane
C#
0 vote305 views7 answers
Python to php converter online
C#
0 vote319 views1 answer
C# summary angle brackets
C#
0 vote346 views1 answer
How disable the back off a panel C#
C#
12 votes339 views4 answers
C# console writeline array
C#
3 votes307 views1 answer
C# writeline
C#
0 vote342 views1 answer
Select range in list c#
C#