如何从List <T>检索项目，其中一个属性恰好包含另一个列表中的单词？

Question

我试图只从List<T>其中一个属性包含另一个列表中的单词的项中检索项目。一旦工作，我将在我的实际数据库上使用该代码，但是以下基本上是我想要做的。List<string> WordsList = new List<string>();WordsList.Add("THIS");WordsList.Add("CAT");List<Sentence> SentencesList = new List<Sentence>();SentencesList.Add(new Sentence { Description = "THIS SENTENCE CONTAINS THE WORD DOG" });SentencesList.Add(new Sentence { Description = "THIS SENTENCE CONTAINS THE WORD CAT" });SentencesList.Add(new Sentence { Description = "THIS SENTENCE CONTAINS THE WORD DOG AND THE WORD CAT" });SentencesList.Add(new Sentence { Description = "THIS SENTENCE CONTAINS NEITHER" });现在，我想从SentencesList中获得仅包含单词"THIS" 和 "CAT“var records = SentencesList.Where(x => WordsList.Any(y => x.Description.Contains(y))).ToList();上面的代码检索所有项目，因为它们包含"THIS" 或 "CAT"

Answer 1

如果你想改变或进入和逻辑，所有你需要做的是改变WordsList.Any成WordsList.All条件：

 var records = SentencesList

   .Where(x => WordsList.All(y => x.Description.Contains(y)))

   .ToList(); 

现在，我们希望所有的话中WordsList是在x