title: Compare two arrays in LINQ query
body: <p>I want to write LINQ query to compare two arrays.  I want the query to be translated to the following query:  </p>
  
  <pre><code>SELECT id, name 
  FROM persons 
  WHERE '{"dance", "acting", "games"}' &amp;&amp; (hobbies);
  </code></pre>
  
  <p>That condition work in that way:  </p>
  
  <pre><code> '{"dance"}' &amp;&amp; '{"dance", "acting", "games"}';  -- true
   '{"dance","singins"}' &amp;&amp; '{"dance", "acting", "games"}';  -- true
   '{"singins"}' &amp;&amp; '{"dance", "acting", "games"}';  -- false
  </code></pre>
  
  <p>I wrote this query:  </p>
  
  <pre><code>List&lt;string&gt; arr = new List&lt;string&gt;(){ "dance", "acting", "games" };
  var query = (from p in _context.Persons
               where arr.Any(kw =&gt; p.hobbies.Contains(kw))
               select new
                    {
                        id = p.id,
                        name = p.name
                    }).ToList();
  </code></pre>
  
  <p>The translated query is:  </p>
  
  <pre><code>SELECT p."id" AS id, p."name" AS name 
  FROM dataBase."Persons" AS p
  </code></pre>
  
  <p>It can understand that the filter performs in the server. so the query brings all the data from DB and filtered on the server. This causes to performance problems and not pass Load-Testing.  </p>
  
  <p>I need a query that will not only do the job but will also be translated to the above query with '&amp;&amp;'.  </p>
  
  <p>Is there any way in LINQ to execute this query?  </p>
  
  <p>Thanks</p>