LINQ to SQL Left Outer Join

by

You don’t need the into statements:

var query = 
    from customer in dc.Customers
    from order in dc.Orders
         .Where(o => customer.CustomerId == o.CustomerId)
         .DefaultIfEmpty()
    select new { Customer = customer, Order = order } 
    //Order will be null if the left join is null

And yes, the query above does indeed create a LEFT OUTER join.

Link to a similar question that handles multiple left joins:
Linq to Sql: Multiple left outer joins

More Related Contents:

  1. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  2. How do I get the MAX row with a GROUP BY in LINQ query?
  3. Why use LINQ Join on a simple one-many relationship?
  4. How to use “contains” or “like” in a dynamic linq query?
  5. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  6. LINQ to Entities does not recognize the method
  7. What is the difference between IQueryable and IEnumerable?
  8. How to do SQL Like % in Linq?
  9. store image in database or in a system file? [closed]
  10. “Or” equivalent in Linq Where() lambda expression
  11. LINQ Single vs First
  12. Extracting files from an Attachment field in an Access database
  13. Linq int to string
  14. EF LINQ include multiple and nested entities
  15. Cannot attach the file *.mdf as database
  16. .NET LINQ query syntax vs method chain
  17. Operation could destabilize the runtime?
  18. How to select only the records with the highest date in LINQ
  19. Does LINQ work with IEnumerable?
  20. How to cancel a long-running Database operation?
  21. Is there a difference between Select * and Select [list each col] [duplicate]
  22. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  23. How to Convert LINQ Comprehension Query Syntax to Method Syntax using Lambda
  24. Get sum of two columns in one LINQ query
  25. LinqToSql declare and instantiate DataContext best practice?
  26. Linq to Objects: does GroupBy preserve order of elements?
  27. LINQ to SQL query using “NOT IN”
  28. Best Practices for uploading files to database
  29. Linq where column == (null reference) not the same as column == null
  30. is it safe to keep database connections open for long time

Leave a Comment