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 vote326 views1 answer
Select range in list c#
C#
11 votes286 views3 answers
C# exit console
C#
0 vote324 views1 answer
One to many relationship in asp net entity framework with role
C#
0 vote314 views1 answer
What dotnet command does
C#
0 vote331 views1 answer
How to detach the camera from the player after death unity
C#Unity
4 votes307 views1 answer
C# remove from list in foreach
C#
129 votes531 views6 answers
C# random generator
C#
0 vote309 views4 answers
Read csv file into wpf C#
C#
0 vote289 views1 answer
C# load button image from resource
C#
34 votes297 views3 answers
Convert text to number C#
C#