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 vote251 views1 answer
Int value from enum in C#
C#
0 vote249 views1 answer
C# substring find word
C#
1 vote284 views1 answer
Unity organize variables in inspector
C#Unity
32 votes365 views6 answers
Unity enable and disable gameobject
C#Unity
0 vote269 views1 answer
DateTime2 error in EF Blazor Web Application
C#
0 vote230 views1 answer
##########
C#
0 vote233 views1 answer
Unity respawn c#
C#
4 votes252 views1 answer
What are access modifiers in c#
C#
2 votes240 views1 answer
Change array size in unity
C#
0 vote261 views1 answer
C# read xml tag value
C#