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 vote182 views1 answer
Vb.net check if datatable has rows
C#
0 vote153 views1 answer
Mouse click unity raycast unity
C#
0 vote146 views1 answer
Membership get user id
C#
0 vote148 views1 answer
Asp.net store list in web.config
C#
7 votes174 views1 answer
How to convert int to string unity c#
C#Unity
0 vote140 views1 answer
List view in unity
C#
0 vote123 views1 answer
C# Convert range
C#
10 votes137 views2 answers
List<string,string> c#
C#
3 votes175 views2 answers
Aspx textarea
C#
0 vote138 views1 answer
Move position smoth unity
C#