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

2 votes237 views1 answer
C# write byte[] to stream
C#
1 vote238 views1 answer
Unity call function on update once per second
C#Unity
0 vote189 views1 answer
Regex c# password numbers and letters
C#
1 vote184 views1 answer
C# copy file to system folder
C#
-1 vote182 views1 answer
How to fix error cs1513 in unity
C#
0 vote197 views1 answer
Vb.net get date minus one day
C#
2 votes197 views1 answer
C# access session in class
C#
0 vote170 views1 answer
How to get last child of gameobject in unity
C#
2 votes179 views2 answers
C# get enum name from value
C#
0 vote243 views1 answer
Unpacking c # tuple
C#