LINQ – Left Join, Group By, and Count

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) }

More Related Contents:

  1. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  2. LINQ Where Ignore Accentuation and Case
  3. Operation could destabilize the runtime?
  4. How to select only the records with the highest date in LINQ
  5. DISTINCT() and ORDERBY issue
  6. Max or Default?
  7. How do I do a left outer join with Dynamic Linq?
  8. Get sum of two columns in one LINQ query
  9. Last and LastOrDefault not supported
  10. Linq where column == (null reference) not the same as column == null
  11. When to use Cast() and Oftype() in Linq
  12. How to get index using LINQ? [duplicate]
  13. How do I concatenate two arrays in C#?
  14. Query an XDocument for elements by name at any depth
  15. What is the point of Lookup?
  16. Metadata were not loaded using MetadataType
  17. Enumerating through an object’s properties (string) in C#
  18. Is the Linq Count() faster or slower than List.Count or Array.Length?
  19. Intersect LINQ query
  20. LINQ – Query syntax vs method chains & lambda [closed]
  21. Resolving extension methods/LINQ ambiguity
  22. Custom Method in LINQ to SQL query
  23. What does this C# code with an “arrow” (=>, an equal sign and greater than sign) mean and how is it called?
  24. Using Linq Except not Working as I Thought
  25. What is the purpose of AsQueryable()?
  26. LINQ query to return a Dictionary
  27. Should the order of LINQ query clauses affect Entity Framework performance?
  28. Map two lists into a dictionary in C#
  29. Is Injection Possible through Dynamic LINQ?
  30. Can I use Linq’s Except() with a lambda expression comparer?

Leave a Comment