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

1 vote129 views1 answer
C# list get object with max value
C#
-1 vote199 views1 answer
Unity public script
C#Unity
2 votes206 views2 answers
OnMousedown unity ui
C#Unity
3 votes176 views1 answer
C# get class name by type
C#
2 votes198 views1 answer
Fade text unity
C#Unity
0 vote187 views1 answer
The terminal process failed to launch: Path to shell executable "dotnet" is not a file or a symlink.
C#
0 vote169 views1 answer
Vb.net remove last comma from string
C#
0 vote206 views1 answer
Unity conditional field
C#Unity
0 vote172 views1 answer
Check shell command success
C#
0 vote171 views1 answer
How prevent user remove file linux
C#