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 vote369 views1 answer
Unity C# make object face away
C#Unity
0 vote306 views1 answer
Unity keep screen always on
C#
0 vote294 views1 answer
On collision enter by layer 2d unity
C#
0 vote320 views1 answer
Dictionary namespace c#
C#
4 votes343 views2 answers
How to make among us clone in unity
C#Unity
4 votes304 views1 answer
How to stop window from terminating c# visual studio
C#
0 vote313 views1 answer
Unity reset random seed
C#
-1 vote360 views3 answers
C# string with double quotes inside
C#
0 vote324 views1 answer
Unity banner ad C#
C#
60 votes410 views6 answers
Print to console c#
C#