EF 多个字段关联条件和左连接

左连接写法

 var query = from f in queryMCFaultResult
                                join e in queryMesFault
                                on f.FaultCode equals e.b.FaultCode
                                join mesRepair in joinMesRepair
                                on **new { A = f.MachineNum, B = e.a.F_ID }** equals
                                **new { A = mesRepair.h.MachineNum, B = mesRepair.h.F_Problem }** 
   /*左连接写法:右表无数据关联时候默认为null*/                              
 into rightRow from rw in rightRow.DefaultIfEmpty()
                                /*rw==null说明MesRepairs表里面没有这个机台维修的历史信息*/
                                where rw==null