linq join on 多条件

来源:互联网 发布:粉红色的火烈鸟 知乎 编辑:程序博客网 时间:2024/06/06 13:43

借助于匿名类型:和解决按多条件分组的思路相同。

from c in CustomerLegalOrgsjoin ao in AccountingOrganizationConfigs on c.OrganizationId equals ao.OrganizationIdjoin ac in AccountingCustomerConfigs on c.CustomerLegalId equals ac.CustomerLegalIdjoin aoc in AccountingOrganizationCustomerConfigs on new{Oid=ao.Id,Cid=ac.Id} equals new{Oid =aoc.AccountingOrganizationConfigId,Cid = aoc.AccountingCustomerConfigId}