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 votes144 views1 answer
Dictionary in c# unity
C#
4 votes129 views1 answer
Unity ui change sprite
C#
1 vote142 views1 answer
Asp.net model
C#
0 vote129 views1 answer
Listview item click c#
C#
7 votes124 views3 answers
C# repeat string x times
C#
0 vote127 views1 answer
StackTrace getframe last frame
C#
7 votes92 views4 answers
How to add text to element javascript
C#
11 votes121 views2 answers
How to check if an integer is in array c#
C#
0 vote131 views1 answer
How to convert output of HttpClient PostAsJsonAsync() into user defined list of object
C#
1 vote163 views1 answer
Get all devices connected using player input manager unity
C#Unity