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

0 vote177 views1 answer
ASP.NET Web Forms TextBox
C#
0 vote173 views1 answer
Unity sprite disappears when using transform.lookat
C#
1 vote168 views1 answer
How to parent something unity
C#
0 vote180 views1 answer
Unity matchinfo
C#
2 votes189 views2 answers
C# create a json object
C#
1 vote184 views1 answer
Assign string value c#
C#
0 vote221 views4 answers
How to get c# code of aspx page
C#
0 vote209 views1 answer
C# how to fill a datatable
C#
4 votes201 views1 answer
Unity replace a text in a string
C#
0 vote178 views1 answer
Fpdf c#
C#