How do you perform a CROSS JOIN with LINQ to SQL?

by

A cross-join is simply the Cartesian product of two sets. There’s no explicit join operator for it.

var combo = from p in people
            from c in cars
            select new
            {
                p.Name,
                c.Make,
                c.Model,
                c.Colour
            };

More Related Contents:

  1. Returning IEnumerable vs. IQueryable
  2. Difference Between Select and SelectMany
  3. Return anonymous type results?
  4. How can I conditionally apply a Linq operator?
  5. LINQ to SQL – Left Outer Join with multiple join conditions
  6. How to do a subquery in LINQ?
  7. Understanding .AsEnumerable() in LINQ to SQL
  8. TransactionScope vs Transaction in LINQ to SQL
  9. LINQ: combining join and group by
  10. How to write Asynchronous LINQ query?
  11. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  12. LINQ Where Ignore Accentuation and Case
  13. Operation could destabilize the runtime?
  14. How to select only the records with the highest date in LINQ
  15. Get table-data from table-name in LINQ DataContext
  16. Linq query with nullable sum
  17. Custom Method in LINQ to SQL query
  18. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  19. LINQ Expression to return Property value?
  20. Max or Default?
  21. Will using LINQ to SQL help prevent SQL injection
  22. How do I do a left outer join with Dynamic Linq?
  23. Get sum of two columns in one LINQ query
  24. Last and LastOrDefault not supported
  25. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  26. Accessing System Databases/Tables using LINQ to SQL?
  27. LINQ to SQL Where Clause Optional Criteria
  28. Linq where column == (null reference) not the same as column == null
  29. If Else in LINQ
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment