c# - Linq to Entities EF4

Question

我有一个包含name、desc 和users(属于该组)集合的 Groups 域模型

我正在尝试获取特定用户所属的所有组。这是我的 LinQ 声明:

var results = from p in AuthorizationService.UnitOfWork.Groups.FindAll()
                          where
                              (p.Users != null && p.Users.Select(u => u.Id).Contains(CurrentUser.Id))
                          select p.Name;

当我尝试执行查询时出现以下错误

Cannot compare elements of type 'System.Collections.Generic.ICollection`1'. Only primitive types (such as Int32, String, and Guid) and entity types are supported.

感谢任何帮助。谢谢!

Answer 1

删除用户对象的空测试，反正它是延迟加载的，你的用户是虚拟的吗？如果是，它是延迟加载的，然后删除空测试就可以了

var results = 
from p in AuthorizationService.UnitOfWork.Groups.FindAll() 
where 
     p.Users.Any(u => u.Id == CurrentUser.Id)
select p.Name;