LINQ to SQL – Left Outer Join with multiple join conditions

by

You need to introduce your join condition before calling DefaultIfEmpty(). I would just use extension method syntax:

from p in context.Periods
join f in context.Facts on p.id equals f.periodid into fg
from fgi in fg.Where(f => f.otherid == 17).DefaultIfEmpty()
where p.companyid == 100
select f.value

Or you could use a subquery:

from p in context.Periods
join f in context.Facts on p.id equals f.periodid into fg
from fgi in (from f in fg
             where f.otherid == 17
             select f).DefaultIfEmpty()
where p.companyid == 100
select f.value

More Related Contents:

  1. How to make LINQ execute a (SQL) LIKE range search
  2. Returning IEnumerable vs. IQueryable
  3. What is the syntax for an inner join in LINQ to SQL?
  4. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  5. Is there a good LINQ way to do a cartesian product?
  6. How can I conditionally apply a Linq operator?
  7. linq case statement
  8. LINQ to SQL and a running total on ordered results
  9. Understanding .AsEnumerable() in LINQ to SQL
  10. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  11. Equivalent of SQL ISNULL in LINQ?
  12. Distinct in Linq based on only one field of the table
  13. Wildcard search for LINQ
  14. Convert Linq Query Result to Dictionary
  15. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  16. Get an IDataReader from a typed List
  17. LINQ Where Ignore Accentuation and Case
  18. Linq query with nullable sum
  19. Join and Include in Entity Framework
  20. Custom Method in LINQ to SQL query
  21. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  22. Max or Default?
  23. Will using LINQ to SQL help prevent SQL injection
  24. How do I do a left outer join with Dynamic Linq?
  25. Calling a SQL User-defined function in a LINQ query
  26. Last and LastOrDefault not supported
  27. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  28. Linq To Sql compare Time only
  29. Is Injection Possible through Dynamic LINQ?
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment