EF linq join多个条件

from order in db.T_ClientWorkOrder
     join
     work in db.T_ClientWorkOrder_Work on order.ID equals work.FK_OrderId
     join
     nodeconfig in db.T_ClientWorkOrder_NodeConfig  on new { key1 = work.NodeKey, key2 = order.ProjectId } equals new { key1 = nodeconfig.NodeKey, key2 = nodeconfig.ProjectId }
where order.OrderCode == orderCode

借助于匿名类型 new出来 key1和 key2

版权声明：本文为lihongyang0453原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。