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

6 votes269 views1 answer
Unity how to see what scen you are in
C#Unity
0 vote194 views1 answer
Get query string parameter from string value c#
C#
0 vote202 views1 answer
Encode pdf file to base64 c#
C#
3 votes224 views2 answers
Monke
C#
0 vote209 views1 answer
Disable alt + f4 in c# forms
C#
2 votes222 views1 answer
Unity c# set object tag
C#
0 vote181 views1 answer
Asp net identity add a unique fields to user
C#
4 votes200 views3 answers
Convert comma separated string to array c#
C#
0 vote251 views1 answer
Enum extends dictionary c#
C#
0 vote188 views1 answer
C sharp tenery operator with callin gmethods
C#