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

8 votes299 views2 answers
Unity respawn
C#Unity
0 vote269 views1 answer
Htmlgenericcontrol class c#
C#
2 votes281 views1 answer
How to pause physics in unity c#
C#
1 vote270 views1 answer
Unity know when gameobject presed
C#
0 vote274 views1 answer
Static readonly variable in c#
C#
14 votes388 views2 answers
How to play animation with code in unity
C#Unity
1 vote319 views1 answer
C# unity change key input in inspector
C#Unity
0 vote278 views1 answer
If input.get touch
C#
0 vote266 views2 answers
Install nuget package for S3
C#
19 votes264 views2 answers
Unity change text
C#