Question

linq主表连接多张附表查询问题

var list = from it in de.WebUser
join a in de.Expertsuer on it.userId equals a.userId
join b in de.Economicuer on it.userId equals b.userId
join c in de.Enterpriseuer on it.userId equals c.userId
join d in de.Instituteuser on it.userId equals d.userId
join e in de.Intermediaryuer on it.userId equals e.userId
join f in de.Schooluser on it.userId equals f.userId
orderby it.userId descending
//where b.Area.Contains(locatring) && it.Audit == 0
where b.Area.Contains(locatring) || c.Area.Contains(locatring) || d.Area.Contains(locatring) || e.Area.Contains(locatring) || f.Area.Contains(locatring)
where it.Audit == 0
select new
{
it.userId,
it.UserName,
it.Iphone,
it.IphoneIs,
it.Email,
it.EmailIs,
it.QQ,
it.RTime,
it.UserClass,
it.Status,
it.Name,
it.userDetail
};

Answer 1

你有什么问题，请把问题描述清楚。
另外你用了两个where