Linq查询(多条件join on查询)

1. IList<RDEquipment> list = null;
3.             list = (from c in gc.GasEquipmentDetail
4.                     join d in gc.GasCompanyRD on c.ForeignID equals d.ID
5.                     join e in gc.GasAttachment on new { ID = c.ID, SourceType = Convert.ToInt32(AttachmentSourceType.Equipment) } equals new { ID = (int)e.SourceID, SourceType = (int)e.SourceType } into EquipmentAtt
6.                     join g in gc.GasDictionary on c.Type equals g.ID
7.                     from att in EquipmentAtt.DefaultIfEmpty()
8.                     where g.Category == "RDEquipment"
9.                     && d.ID == forid
10.                     && c.IsDeleted == 0
11.                     select new RDEquipment
12.                     {
13.                         EquipmentType = g.Title,
14.                         EqpID = c.ID,
15.                         EquipmentName = c.EquipmentName,
16.                         Quantity = c.Quantity,
17.                         AttID = att.ID,
18.                         FileName = att.FileName,
19.                         FilePath = Gasgoo.Framework.AttachDirFactory.GetAttachPath(AttachmentSourceType.Equipment, att.FilePath)
20.                     }).ToList<RDEquipment>();

join ... on new { ID = c.ID, SourceType = Convert.ToInt32(AttachmentSourceType.Equipment) } 

equals new { ID = (int)e.SourceID, SourceType = (int)e.SourceType }

相当于sql语句中join ... on c.ID=e.SourceID and sourcetype=e.sourcetype