如何使用LINQ to SQL执行CROSS JOIN？

解决方案

回答

交叉联接只是两组的笛卡尔乘积。没有它的显式联接运算符。

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

回答

根据史蒂夫的回答，最简单的表达是这样的：

var combo = from Person in people
            from Car    in cars
            select new {Person, Car};