LINQ

from p in context.ParentTablejoin c in context.ChildTable on p.ParentId equals c.ChildParentId into j1from j2 in j1.DefaultIfEmpty()group j2 by p.ParentId into groupedselect new { ParentId = grouped.Key, Count = grouped.Count(t=>t.ChildId != null) }