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

21 votes171 views2 answers
Unity set object scale
C#
1 vote168 views1 answer
C# get count from unknown list
C#
0 vote170 views1 answer
C# how to get connection string from app config
C#
2 votes166 views1 answer
New color unity
C#
1 vote170 views1 answer
C# generic return type in interface
C#
0 vote131 views1 answer
C# verify "no other" call xunit
C#
0 vote181 views1 answer
C# networkstream read all bytes
C#
0 vote205 views1 answer
Sequelize instance method is not a function
C#
0 vote226 views1 answer
Check if object has parent unity
C#Unity
1 vote172 views1 answer
How to detect mouse click in c#
C#