如何在linq查询中设置内部连接
如何在linq查询中设置内部连接
提问于 2021-05-12 20:06:41
我想在linq查询中设置内部联接
这是我的密码
var JoinUsingMS = from emp in _productRepository.Table
join address in _purchaseReminderRepository.Table
on new { c1 = emp.VendorId, c2 = emp.Name } equals new { c1 = address.VendorId, c2 = address.Product } into bp_sm
from c in bp_sm.DefaultIfEmpty()
where emp.Published == true
select emp;从这个查询中，我得到了join (通过调试跟踪)。虽然我认为是这样，但是这个查询对于内部连接) (引用链接仍然输出左连接)来说是完美的。
回答 2
Stack Overflow用户
发布于 2021-05-12 22:28:26
下面是内部联接的更新查询：
var JoinUsingMS = from emp in _productRepository.Table
join address in _purchaseReminderRepository.Table
on new { c1 = emp.VendorId, c2 = emp.Name }
equals new { c1 = address.VendorId, c2 = address.Product }
where emp.Published == true
select emp;Stack Overflow用户
发布于 2021-05-13 15:43:29
很简单。删除DefaultIfEmpty行。这就是创建左联接子句的原因：
var JoinUsingMS =
from emp in _productRepository.Table
join address in _purchaseReminderRepository.Table
on new { c1 = emp.VendorId, c2 = emp.Name } equals new { c1 = address.VendorId, c2 = address.Product } // into bp_sm
// from c in bp_sm.DefaultIfEmpty()
where emp.Published == true
select emp;页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/67513761
复制相关文章
相似问题
腾讯云开发者
