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 vote193 views1 answer
How to clear datagridview c#
C#
1 vote190 views1 answer
Why v-slot not working in vue 3
C#
2 votes248 views5 answers
Photon
C#
2 votes196 views1 answer
Linq query select top 1 c#
C#
3 votes244 views3 answers
C# console foreground color
C#
1 vote183 views2 answers
Getcomponent
C#
9 votes149 views1 answer
Unity car controller script c# download
C#
0 vote173 views1 answer
Blazor image button
C#
2 votes230 views1 answer
C# Switch and case
C#
1 vote169 views1 answer
How to configure session timeout in asp.net core
C#