首先呢,今天在数据库中写好了笛卡尔连接,后面要改写成LINQ的方式。突然瞬间蒙了,写多了JOIN却忘了怎么去写交叉连接(笛卡尔连接)。
顺便复习一下LINQ的连接操作:
static public class SampleData
{
static public Student[] Students =
{
new Student {Name="Richard"},
new Student {Name="Joe"},
new Student {Name="Tom"}
};
static public Subject[] Subjects =
{
new Subject {Name="语文"},
new Subject {Name="数学"},
new Subject {Name="英语"}
};
static public Book[] Books =
{
new Book {
Title="人教版语文",
PublicationDate=new DateTime(2004, 11, 10),
Subject=Subjects[0]
},
new Book {
Title="苏教版语文",
PublicationDate=new