我正在尝试合并两个LINQ查询,但是结果并不符合我的期望。
List<TeacherSubjectVM> query = (from t in uow.staffs
join ts in uow.teachersubjects on t.ID equals ts.teacherID
join s in uow.subjects on ts.subjectID equals s.ID
select new TeacherSubjectVM
{
subjectName = s.Name,
teacherName = t.fname,
}).ToList();
List<TeacherSubjectVM> query1 = (from t in uow.subjects
join ts in uow.classsubjects on t.ID equals ts.subjectID
join s in uow.jamats on ts.subjectID equals s.ID
select new TeacherSubjectVM
{
section = s.section,
className = s.name,
}).ToList();
List<TeacherSubjectVM> combine = query.Concat(query1).ToList();
课程名称和班级应该与教师名称在同一行: