title: EF Core string contains string array
body: <p>Is it possible to check with EF Core if a string contains a string[]</p>
  <p>For example, I have a database table that has comma separated keywords in one columns. I want to get related records that also contain these keywords. The way I tried it:</p>
  <pre><code>public class Item {
  
    int Id { get; set; }
  
    string Keywords { get; set; }
  
  }
  </code></pre>
  <pre><code>var keywords = item.Keywords.Split(',');
  
  var result = context.Items.Where(i =&gt; keywords.Any(j =&gt; i.Keywords.Contains(j)).ToListAsync();
  </code></pre>
  <p>This will throw a error message:</p>
  <blockquote>
  <p>The LINQ expression 'DbSet().Where(g =&gt; __keywords_0.Any(j =&gt;
  g.Keywords.Contains(j)))' could not be translated.</p>
  </blockquote>
  <p>So how wil I rewrite this so that it can be translated to SQL? It is not an option to get a complete list and checking it with C#. It is also not possible to convert a comma seperated keyword list to it's own table.</p>