各位前輩大家好,本人最近剛開始接觸LINQ相關(guān)的知識(shí),今天在練習(xí)的時(shí)候遇到一個(gè)多表的查詢,想來想去不知道怎么下手,所以來這里問問各位前輩,希望能夠得到解答.這個(gè)是我需要實(shí)現(xiàn)的窗體:需要通過上方的條件組合查詢出結(jié)果,并且結(jié)果來自不同的數(shù)據(jù)表.  下面是ER圖:  以及我自己寫的部分代碼: var dt = (from a in db.ClassInfojoin b in db.TeacherInfo on a.TeacherID equals b.IDjoin c in db.MajorInfo on a.MajorID equals c.IDjoin d in db.StudentInfo on a.ID equals d.ClassIDjoin f in db.DepartmentInfo on c.DepartmentID equals f.IDjoin g in db.UserInfo on b.UserID equals g.IDwhere f.DepartmentName.Contains(XBName) &&c.MajorName.Contains(ZYName) &&a.ClassNo.Contains(classNo) &&a.ClassName.Contains(className) &&g.UserName.Contains(classTeacher) select new { f.DepartmentName,c.MajorName,a.ClassNo,a.ClassName,g.UserName }).Where(i=>true).ToList();gridInfos.DataSource = dt; 補(bǔ)充: studentInfo表中的status 字段 :1在校,2退學(xué),3休學(xué)