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