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

10 votes199 views4 answers
Unity array c#
C#
4 votes228 views3 answers
Unity singleton
C#
0 vote170 views1 answer
C# web scraping get images from specific url
C#
0 vote188 views1 answer
How to check type c#
C#
1 vote195 views1 answer
Emboss button in android app
C#
0 vote183 views1 answer
C# create class from parent class
C#
13 votes191 views2 answers
C# list to array
C#
2 votes179 views1 answer
How to change the position of a gameobject in c# unity
C#
-1 vote191 views1 answer
C# for loop last iteration
C#
9 votes278 views3 answers
Find gameobject unity
C#Unity