linq
通用类和字段
定义老师类和学生类,学生类中有老师的ID
public class Student
{
public int Id {
get; set; }
public string Name {
get; set; }
public int TeacherID {
get; set; }
}
public class Teacher
{
public int Id {
get; set; }
public string Name {
get; set; }
}
定义一个连接后的数据类
public class StuTea
{
public int StuId {
get; set; }
public string StuName {
get; set; }
public int TeaId {
get; set; }
public string TeaName {
get; set; }
public override string ToString()
{
return string.Format("学生id:{0},学生name:{1},老师id:{2},老师name:{3}",StuId,StuName,TeaId,TeaName);
}
}
public class StuTeaG
{
public Student Stu {
get; set; }
public Teacher Tea {
get; set; }
public override string ToString()
{
return string.Format("学生id:{0},学生name:{1},老师id:{2},老师name:{3}",
Stu==null?-1: Stu.Id,Stu==null?"": Stu.Name, Tea == null?-1: Tea.Id, Tea == null?"": Tea.Name);
}
}
初始化学生数据和老师数据