Linq联接
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace Linq联接
{
class Program
{
public class Student
{
public int stID;
public string LastName;
}
public class CourseStudent
{
public string CourseName;
public int stID;
}
static Student[] students = new Student[] {
new Student { stID = 1, LastName = "Carson" } ,
new Student { stID = 2, LastName = "Jack" },
new Student { stID = 3, LastName = "Tom" }
};
static CourseStudent[] courseStudents = new CourseStudent[]{
new CourseStudent{CourseName="asd",stID=1},
new CourseStudent{CourseName="asd",stID=2},
new CourseStudent{CourseName="sfh",stID=1},
new CourseStudent{CourseName="dgfsd",stID=2},
new CourseStudent{CourseName="dgfsd",stID=3},
};
static void Main(string[] args)
{
var query = from s in students //s和c是迭代器
join c in courseStudents
on s.stID equals c.stID
where c.CourseName == "asd"
select s.LastName;
foreach (var q in query)
Console.WriteLine("Student Taking asd :{0}",q);
Console.ReadKey();
}
}
}
