How do you perform a left outer join using linq extension methods

by

For a (left outer) join of a table Bar with a table Foo on Foo.Foo_Id = Bar.Foo_Id in lambda notation:

var qry = Foo.GroupJoin(
          Bar, 
          foo => foo.Foo_Id,
          bar => bar.Foo_Id,
          (x,y) => new { Foo = x, Bars = y })
       .SelectMany(
           x => x.Bars.DefaultIfEmpty(),
           (x,y) => new { Foo=x.Foo, Bar=y});

More Related Contents:

  1. Entity framework left join
  2. LINQ Inner-Join vs Left-Join
  3. Get all checked nodes of a treeview
  4. Difference Between Select and SelectMany
  5. How to do joins in LINQ on multiple fields in single join
  6. printing all contents of array in C#
  7. Quickest way to compare two generic lists for differences
  8. How do I use LINQ Contains(string[]) instead of Contains(string)
  9. Sequence contains no elements?
  10. Concat all strings inside a List using LINQ
  11. Func with out parameter
  12. Sorting a list using Lambda/Linq to objects
  13. Determine if a sequence contains all elements of another sequence using Linq [duplicate]
  14. Linq to EntityFramework DateTime
  15. how to check if object already exists in a list
  16. How to Bulk Update records in Entity Framework?
  17. Linq order by, group by and order by each group?
  18. Find character with most occurrences in string?
  19. Why use AsQueryable() instead of List()?
  20. C#: How to convert a list of objects to a list of a single property of that object?
  21. linq group by contiguous blocks
  22. convert this LINQ expression into Lambda
  23. how do I chunk an enumerable?
  24. Code equivalent to the ‘let’ keyword in chained LINQ extension method calls
  25. How to sort a dictionary by key
  26. LINQ performance Count vs Where and Count
  27. Issues Doing a String Comparison in LINQ
  28. Select all columns after JOIN in LINQ
  29. Accessing System Databases/Tables using LINQ to SQL?
  30. Parsing a string C# LINQ expression

Leave a Comment