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

3 votes102 views2 answers
How to freeze x and y position in rb2d with code unity
C#
0 vote100 views1 answer
Dirty property unity
C#
0 vote103 views1 answer
Dictionary instanciation
C#
4 votes92 views1 answer
Isprime c#
C#
1 vote106 views1 answer
Rigidbody.addtorque
C#
1 vote109 views1 answer
C# error CS0515
C#
0 vote60 views1 answer
Creating a Web API Controller with param or [FromBody]dynamic type
C#
0 vote122 views3 answers
Count number of specific characters in string c#
C#
0 vote88 views1 answer
C# linq remove duplicate items from list of integer
C#
0 vote117 views1 answer
Or c#
C#