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();
}
}
}
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步