mysql 的sql语句与Linq

Question

SELECT dept.DepartmentId,dept.DptName FROM tbldepartment as dept
JOIN tblconsult as consult on dept.DepartmentId in (consult.DepartmentId ,consult.ApplyDepartmentId)
where consult.Id = 726

这个语句用linq 怎么写 ，主要是 dept.DepartmentId in (consult.DepartmentId ,consult.ApplyDepartmentId) 这一句

Answer 1

 linq的join不支持条件判断，所以要用linq就不能用join了

var query = from dept in tbldepartment
from consult in  tblconsult
where dept.DepartmentId == consult.DepartmentId || dept.DepartmentId == consult.ApplyDepartmentId
select new { dept.DepartmentId, dept.DptName };