c#多表联查

最新推荐文章于 2024-07-13 21:58:32 发布

Bulusi.li

最新推荐文章于 2024-07-13 21:58:32 发布

阅读量1.6k

点赞数

文章标签： c# linq 多表查询

本文链接：https://blog.csdn.net/lijun6666666666/article/details/117444724

版权

知识点：Linq from

在这里插入图片描述

var marketDetails = from detail in _marketDetailRepository.GetAll().Where(s => s.MarketNo == no && s.IsDeleted == false)
                                join specification in _productSpecificationRepository.GetAll().Where(t => t.IsDeleted == false)
                                on detail.SpecificationNo equals specification.SpecificationNo
                                join productType in _productTypeRepository.GetAll().Where(t => t.IsDeleted == false)
                                on specification.Type equals productType.TypeNo
                                join unit in _measuringUnitRepository.GetAll().Where(t => t.IsDeleted == false)
                                on specification.UnitNo equals unit.UnitNo
                                select new MarketDetailDto
                                {
                                    Id = detail.Id,
                                    SpecificationNo = specification.SpecificationNo,
                                    SpecificationName = specification.SpecificationName,
                                    Specification = specification.Specification,
                                    Price = specification.PurchasePrice,
                                    Type = productType.TypeName,
                                    Unit = unit.UnitName,
                                    Number = detail.Number,
                                };