实体框架上可查询的多个.Where()子句 [英] Multiple .Where() clauses on an Entity Framework Queryable

问题描述

我正在尝试使用Entity Framework实现复杂的过滤器:我想根据提供的搜索条件向可查询对象添加where子句.

I am trying to implement a complex filter using Entity Framework: I want to add where clauses to the queryable object based on my provided search criteria.

我可以在Entity Framework 6中执行以下操作吗?

Can I do the following in Entity Framework 6?

var queryable = db.Users.Where(x => x.Enabled && !x.Deleted);
// Filter
var userId = User.Identity.GetUserId();
queryable.Where(x => x.AspNetUser.Id == userId);
queryable.Where(x => x.Status >= 2); 
// ...etc

我知道我可以做到:

var queryable = db.Users
 .Where(x => x.Enabled && !x.Deleted)
 .Where(x => x.AspNetUser.Id == userId)
 .Where(x => x.Status >= 2); 

但是此解决方案无法获得预期的结果.似乎忽略了两个where子句的秒数.

But I am not getting the expected results with this solution. It seems to be ignoring the seconds two where clauses.

推荐答案

.Where返回可查询的内容，它不会修改原始内容.因此，您只需要保存新的可查询对象即可.

.Where returns a queryable, it does not modify the original. So you just need to save the new queryable.

var queryable = db.Users.Where(x => x.Enabled && !x.Deleted);
// Filter
var userId = User.Identity.GetUserId();
queryable = queryable.Where(x => x.AspNetUser.Id == userId);
queryable = queryable.Where(x => x.Status >= 2); 
// ...etc

这篇关于实体框架上可查询的多个.Where()子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！