Linq to SQL 表与表之间关联

join语句：

join语句
 var query = from tblMaterialInZhiSi in objPlantDataClassesDataContext.tbl_MaterialInZhiSiMachineInfo
                            join tblZhiSiInfo in objPlantDataClassesDataContext.tbl_ZhiSiMachineInfo
                            on tblMaterialInZhiSi.MatInZS_ZhiSiMachineId equals tblZhiSiInfo.ZSMach_Id
                            where tblZhiSiInfo.ZSMach_Werks.Equals(strWerks)
                            select new
                            {
                                tblMaterialInZhiSi,
                                tblZhiSiInfo
                            };
 foreach (var tem in query)
                {
                 //tem.tblMaterialInZhiSi;
                 //tem.tblZhiSiInfo
}

转载于:https://www.cnblogs.com/boer/archive/2009/04/26/1443784.html