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

xk_hypothesis

于 2024-06-05 17:37:49 发布

阅读量167

点赞数 3

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

本文链接：https://blog.csdn.net/xk_hypothesis/article/details/139478165

版权

EFCore 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

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();