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

2 votes225 views1 answer
C# create array of number from number
C#
1 vote217 views1 answer
Convert bytes to string and back c#
C#
0 vote251 views1 answer
Unity rb.addexplosionforce 2d
C#Unity
1 vote187 views2 answers
C# random choice
C#
1 vote213 views1 answer
Loan calculator using windows forms in c# code
C#
2 votes213 views2 answers
String to list c#
C#
0 vote218 views1 answer
Make tooltip disappear c#
C#
0 vote218 views1 answer
How to change the width of a panel unity
C#
0 vote221 views3 answers
C3 compare hour
C#
50 votes215 views4 answers
Unity how to load a scene
C#