How do you perform a CROSS JOIN with LINQ to SQL?
From stackoverflow
Luke Smith
-
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 };
From Steve Morgan -
Based on Steve's answer, the simplest expression would be this:
var combo = from Person in people from Car in cars select new {Person, Car};
From Mark Cidade
0 comments:
Post a Comment