How to implement left join in JOIN Extension method

by

Normally left joins in LINQ are modelled with group joins, sometimes in conjunction with DefaultIfEmpty and SelectMany:

var leftJoin = p.Person.Where(n => n.FirstName.Contains("a"))
                       .GroupJoin(p.PersonInfo, 
                                  n => n.PersonId,
                                  m => m.PersonId,
                                  (n, ms) => new { n, ms = ms.DefaultIfEmpty() })
                       .SelectMany(z => z.ms.Select(m => new { n = z.n, m }));

That will give a sequence of pairs (n, m) where n is the entry from p.Person and m is the entry from p.PersonInfo, but m will be null if there are no matches.

(It’s completely untested, btw – but should give you the idea anyway 🙂

More Related Contents:

  1. Convert string[] to int[] in one line of code using LINQ
  2. Extension methods must be defined in a non-generic static class
  3. Why doesn’t Include have any effect?
  4. Why can’t I call an extension method from a base class of the extended type‏?
  5. Extension methods syntax vs query syntax
  6. Resolving extension methods/LINQ ambiguity
  7. What is the performance of the Last() extension method for List?
  8. Code equivalent to the ‘let’ keyword in chained LINQ extension method calls
  9. linq syntax: What is the type that this returns? How can I now go ahead and use firstRow.ingredientName etc?
  10. Retrieving Property name from lambda expression
  11. Mocking Extension Methods with Moq
  12. When to use BlockingCollection and when ConcurrentBag instead of List?
  13. Detect target framework version at compile time
  14. How to get the index of an element in an IEnumerable?
  15. How do I invoke an extension method using reflection?
  16. Find index of a value in an array
  17. Interesting “params of ref” feature, any workarounds?
  18. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  19. Linq query built in foreach loop always takes parameter value from last iteration
  20. Entity Framework. Delete all rows in table
  21. Find() vs. Where().FirstOrDefault()
  22. How to Get XML Node from XDocument
  23. FindAll vs Where extension-method
  24. Linq to Entity Join table with multiple OR conditions
  25. Possible pitfalls of using this (extension method based) shorthand
  26. LINQ to Entities does not recognize the method ‘Int32 Parse(System.String)’ method, and this method cannot be translated into a store expression
  27. Linq style “For Each” [duplicate]
  28. LINQ: Add RowNumber Column
  29. How to include() nested child entity in linq
  30. LINQ query — Data aggregation (group adjacent)

Leave a Comment