子查询linq语句，求个答案。该如何解决-C#教程-爱易网页

子查询linq语句，求个答案。该如何解决

日期：2014-05-20　浏览次数：20979 次

子查询linq语句，求个答案。
select * from dbo.BaseEmployee left join hrPersInfo
ON BaseEmployee.EmpID =hrPersInfo.EmpID
WHERE BaseEmployee.EmpID NOT IN
( select EmpID from dbo.hrPersInfo)
------解决方案--------------------
from be in db.BaseEmployee
join pi in db.hrPersInfo
on be.EmpID equals pi.EmpID
where db.hrPersInfo.Select(x => x.EmpID).All(x => x != be.EmpID)

or

from be in db.BaseEmployee
join pi in db.hrPersInfo
on be.EmpID equals pi.EmpID
where !db.hrPersInfo.Select(x => x.EmpID).Contians(be.EmpID)
------解决方案--------------------

引用:

from be in db.BaseEmployee
join pi in db.hrPersInfo
on be.EmpID equals pi.EmpID
where db.hrPersInfo.Select(x => x.EmpID).All(x => x != be.EmpID)

or

from be in db.BaseEmployee
join pi in db.hrPersInfo
on be.EmpID equals pi.EmpID
where !db.hrPersInfo.Select(x => x.EmpID).Contians(be.EmpID)

版主貌似没有加左连接

select * from dbo.BaseEmployee left join hrPersInfo
------解决方案--------------------

引用:

from be in db.BaseEmployee
join pi in db.hrPersInfo
on be.EmpID equals pi.EmpID
where db.hrPersInfo.Select(x => x.EmpID).All(x => x != be.EmpID)

or

from be in db.BaseEmployee
join pi in db.hrPersInfo
on be.EmpID equals pi.EmpID
where !db.hrPersInfo.Select(x => x.EmpID).Contians(be.EmpID)

from be in db.BaseEmployee
join pi in db.hrPersInfo into NewhrPersInfo
from pi from NewhrPersInfo.DefaultIfEmpty()
on be.EmpID equals pi.EmpID
where db.hrPersInfo.Select(x => x.EmpID).All(x => x != be.EmpID)
------解决方案--------------------

引用:

select * from dbo.BaseEmployee left join hrPersInfo
ON BaseEmployee.EmpID =hrPersInfo.EmpID
WHERE BaseEmployee.EmpID NOT IN
( select EmpID from dbo.hrPersInfo)

怎么看这SQL语句，都觉得蛋疼~ 你这SQL语句里的left join这句有意义么

var query= from be in BaseEmployee

           where !hrPersInfo.Select(h=>h.EmpID).Contains(be.EmpID)

           select be;

------解决方案--------------------
linq和SQl版块回答问题率好高啊，都是高手啊。。。

------解决方案--------------------

引用:

Quote: 引用:

select * from dbo.BaseEmployee left join hrPersInfo
ON BaseEmployee.EmpID =hrPersInfo.EmpID
WHERE BaseEmployee.EmpID NOT IN
( select EmpID from dbo.hrPersInfo)

怎么看这SQL语句，都觉得蛋疼~ 你这SQL语句里的left join这句有意义么
var query= from be in BaseEmployee

           where !hrPersInfo.Select(h=>h.EmpID).Contains(be.EmpID)

           select be;

没整体看丢人了！

免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。

子查询linq语句，求个答案。该如何解决

相关资料更多>

推荐阅读更多>