【EF】多表查询，左联接

最新推荐文章于 2024-04-30 21:37:37 发布

GreAmbWang

最新推荐文章于 2024-04-30 21:37:37 发布

阅读量564

点赞数

分类专栏： EF

本文链接：https://blog.csdn.net/weixin_38211198/article/details/105071946

版权

EF 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

这是内联接

DataModelContainer db = new DataModelContainer();
var dataModels = from slide in db.Slide
                 join slideBarcode in db.SlideBarcode on slide.ID equals slideBarcode.SlideID
                 where slide.IsDeleted == false && slide.CaseID == caseId
                 orderby slide.ID
                 select new Slide
                 {
                     SlideID = slide.ID,
                     Description = slide.Description,
                     CreatedDate = slide.CreatedDate,

                     Barcode = slideBarcode .Barcode,
                     PrintDate = slideBarcode .PrintDate
                 };

这是左联接

DataModelContainer db = new DataModelContainer();
var dataModels = from slide in db.Slide
                 join slideBarcode in db.SlideBarcode on slide.ID equals slideBarcode.SlideID into slidebarcode
                 from sb in slidebarcode.DefaultIfEmpty()
                 where slide.IsDeleted == false && slide.CaseID == caseId
                 orderby slide.ID
                 select new Slide
                 {
                     SlideID = slide.ID,
                     Description = slide.Description,
                     CreatedDate = slide.CreatedDate,

                     Barcode = sb.Barcode,
                     PrintDate = sb.PrintDate
                 };

使用into和DefaultIfEmpty()方法