LINQ Join with Multiple Conditions in On Clause

by

You just need to name the anonymous property the same on both sides

on new { t1.ProjectID, SecondProperty = true } equals 
   new { t2.ProjectID, SecondProperty = t2.Completed } into j1

Based on the comments of @svick, here is another implementation that might make more sense:

from t1 in Projects
from t2 in Tasks.Where(x => t1.ProjectID == x.ProjectID && x.Completed == true)
                .DefaultIfEmpty()
select new { t1.ProjectName, t2.TaskName }

More Related Contents:

  1. Simple Linq query has duplicated join against same table?
  2. Greater Than Condition in Linq Join
  3. Multiple “order by” in LINQ
  4. Linq: adding conditions to the where clause conditionally
  5. How to filter nested collection Entity Framework objects?
  6. Only initializers, entity members, and entity navigation properties are supported
  7. Linq with group by having count
  8. LINQ Between Operator
  9. LINQ join two DataTables
  10. LINQ OrderBy versus ThenBy
  11. LINQ: combining join and group by
  12. What’s the difference between IQueryable and IEnumerable [duplicate]
  13. How can I reject all changes in a Linq to SQL’s DataContext?
  14. How to use LINQ in C++/CLI – in VS 2010/.Net 4.0
  15. Sum of items in a collection
  16. LINQ To SQL exception: Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains operator
  17. writing a custom comparer for linq groupby
  18. Linq To Sql – Dynamic OrderBy – Case When
  19. What Sorting Algorithm Is Used By LINQ “OrderBy”?
  20. How LINQ works internally?
  21. LINQ OrderBy not ordering .. changing nothing .. why?
  22. Multiple WHERE clause in Linq
  23. LINQ: Entity string field contains any of an array of strings
  24. ASP.NET Core & EntityFramework Core: Left (Outer) Join in Linq
  25. LINQ Include vs Join. Are they equivalent?
  26. Tradeoffs using NHibernate 3.0 QueryOver or LINQ provider
  27. If condition in LINQ Where clause
  28. Point connectionstring in dbml to app.config
  29. Building Dynamic LINQ Queries based on Combobox Value
  30. NHibernate vs LINQ to SQL

Leave a Comment