EFCore 连表查询的WhereIf条件的使用示例

最新推荐文章于 2024-07-18 18:11:03 发布

xk_hypothesis

最新推荐文章于 2024-07-18 18:11:03 发布

阅读量543

点赞数 4

分类专栏： EFCore 文章标签： .net

本文链接：https://blog.youkuaiyun.com/xk_hypothesis/article/details/139478165

版权

EFCore 专栏收录该内容

3 篇文章

订阅专栏

var query = from a in _DbContext.ProductInfo.AsNoTracking()
            join b in _DbContext.FinalAssemKeyPartBindings.AsNoTracking()
            on a.ProductInfoID equals b.ProductInfoID
            select new { a,b};
var list = query.Where(s => subOrderIds.Contains(s.a.SubManufacturingOrderID))
    .WhereIf(isFilterSerialCode, s => s.a.BikeSerialCode.Contains(search.SerialCode))
    .WhereIf(isFilterBikeFrameCode, s => s.b.KeyUniqueCode.Contains(search.BikeFrameCode))
    .Select(s => new {p = s.a,f = s.b}).ToList();