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

xk_hypothesis

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

阅读量561

点赞数 4

CC 4.0 BY-SA版权

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

本文链接：https://blog.csdn.net/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();