c# - Entity Framework .Any() 过滤器出错

Question

这是我的查询:

var x = db
   .Users
   .Where(u => u.Locations.Any(l => searchedLocation.Counties.Any(c => c.LocationId == l.LocationId));

上下文:

• Users是IQueryable<User> . (EF 对象集)
• searchedLocation是 Location对象。
• Counties是 ICollection<MiniLocation> .

我正在尝试做的事情:

Return all users, where any of the Counties for those locations have a locationId of any of the counties belonging to the searched location.

示例:

搜索纽约市(LocationId = 1. County1LocationId = 2)

用户:鲍勃。地点:Soho。 County1LocationId = 2. County2 LocationId = 3.

所以这是一场比赛。 (因为 Soho 有一个 LocationId 为 2 的县，纽约市也是)

我收到的错误:

Unable to create a constant value of type 'xxx.xxx.Locations.MiniLocation'. Only primitive types ('such as Int32, String, and Guid') are supported in this context.

有什么想法吗？

Answer 1

这MSDN page声明不支持此构造。您可以使用 this method .Net 3.5 Linq to Entities 帮助替换 Any 的使用。