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

Question

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

Answer 1

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
            };