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 vote71 views1 answer
Report background worker
C#
-1 vote108 views2 answers
C# string contain double quote
C#
0 vote120 views1 answer
C# split string by index
C#
0 vote139 views3 answers
Count number of specific characters in string c#
C#
0 vote119 views1 answer
C# datatable current row
C#
0 vote160 views2 answers
Add RowDefinition from cs xamarin
C#
3 votes116 views2 answers
Unity pause scene
C#
0 vote108 views1 answer
How to change samesite=lax to samesite=none in asp.net
C#
1 vote118 views1 answer
C# start as adminstrator
C#
0 vote116 views1 answer
C# remove
C#