c# - LinQ 到实体 : Doing the opposite query

Question

我是这样写的:

var destinations = db.DestinationDetails.
    Where(dd => dd.Language.Lang == "en-US" &&
        dd.Destination.Client.Any(c => c.Email == "abc@yahoo.com"));

如何检索电子邮件为 abc@yahoo.com 的客户没有的目的地详细信息？

这行不通:

var destinations = db.DestinationDetails.
    Where(dd => dd.Language.Lang == "en-US" &&
        dd.Destination.Client.Any(c => c.Email != "abc@yahoo.com"));

谢谢!

Answer 1

我认为您想使用 All 而不是 Any:

dd.Destination.Client.All(c => c.Email != "abc@yahoo.com")