c# - Linq-to-SQL反向包含

Question

我如何反转 Linq-to-SQL 查询中的包含，以便我可以检查 Title 或 Description 是否包含我列表中的任何单词，例如:

var query = context.Shapes.Where(x => x.Title.Contains(words));

这是我现在拥有的，但与我需要的相反。

 List<string> words = Search.GetTags(q);
 //words = round,circle,square

 using(ShapesDataContext context = new ShapesDataContext())
 {
    var query = context.Shapes.Where(x => words.Contains(x.Title) || 

    words.Contains(x.Description));
 }

// Item 1: Title = Elipse , Decsription = This is not round circle
//This should be a match! but words doesn't contain 
//"This is not round circle", only round and circle so no match

更新

现在我有

  var query = context.Shapes.Where(x => words.Any(w => x.Title.Contains(w) || x.Description.Contains(w)))
  int s = query.Count();

但现在我在 int s = query.Count(); 上收到异常消息“本地序列不能用于查询运算符的 LINQ to SQL 实现中，但 Contains 运算符除外。”有谁知道怎么解决吗？

Answer 1

你想要

x => words.Any(w => x.Title.Contains(w) || x.Description.Contains(w))