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 vote112 views2 answers
Timespan format string c#
C#
3 votes112 views1 answer
Add leading zeroes in c#
C#
0 vote133 views1 answer
Make all variables nonserizlized unity
C#Unity
0 vote179 views1 answer
Unity c# find object position in array
C#Unity
0 vote110 views1 answer
How to hide cell in epplus
C#
8 votes117 views2 answers
C# round to 2 decimal places
C#
5 votes146 views1 answer
Unity movetowards 2d
C#Unity
4 votes114 views1 answer
Print content of array c#
C#
0 vote115 views1 answer
Scale curve revit api
C#
1 vote123 views1 answer
Unity gameobject.findobjectswith tag set active
C#