Why use LINQ Join on a simple one-many relationship?

by

It’s usually a mistake.

@George is correct that your two examples are functionally different in a way which has nothing to do with join vs non-join, however. But you could just as easily write:

var redProducts = context.Category
                         .Where(c => c.Name == "red")
                         .SelectMany(c => c.Products);

…which is functionally identical (but superior from a readability and maintainability POV) to your join example.

More Related Contents:

  1. LINQ to Entities does not recognize the method
  2. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  3. How to do SQL Like % in Linq?
  4. LINQ to SQL Left Outer Join
  5. Why is LINQ JOIN so much faster than linking with WHERE?
  6. Linq to Entities – SQL “IN” clause
  7. How do I get the MAX row with a GROUP BY in LINQ query?
  8. Linq int to string
  9. LINQ, can’t join to string
  10. How to use “contains” or “like” in a dynamic linq query?
  11. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  12. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  13. Which method performs better: .Any() vs .Count() > 0?
  14. What is the difference between IQueryable and IEnumerable?
  15. Case insensitive string compare in LINQ-to-SQL
  16. “Or” equivalent in Linq Where() lambda expression
  17. LINQ Single vs First
  18. LINQ: combining join and group by
  19. EF LINQ include multiple and nested entities
  20. .NET LINQ query syntax vs method chain
  21. Operation could destabilize the runtime?
  22. How to select only the records with the highest date in LINQ
  23. Ignore namespaces in LINQ to XML
  24. Does LINQ work with IEnumerable?
  25. Why does IQueryable.All() return true on an empty collection?
  26. How to Convert LINQ Comprehension Query Syntax to Method Syntax using Lambda
  27. Get sum of two columns in one LINQ query
  28. LinqToSql declare and instantiate DataContext best practice?
  29. Linq to Objects: does GroupBy preserve order of elements?
  30. How to return a page of results from SQL?

Leave a Comment