title: Entity Framework - attribute IN Clause usage
body: <p>I need to filter some Entities by various fields using "normal" WHERE and IN clauses in a query over my database, but I do not know how to do that with EF.</p>
  
  <p>This is the approach:</p>
  
  <p><em>Database table</em></p>
  
  <pre><code>Licenses
  -------------
  license INT
  number INT
  name VARCHAR
  ...
  </code></pre>
  
  <p><em>desired SQL Query in EF</em></p>
  
  <pre><code>SELECT * FROM Licenses WHERE license = 1 AND number IN (1,2,3,45,99)
  </code></pre>
  
  <p>EF Code</p>
  
  <pre><code>using (DatabaseEntities db = new DatabaseEntities ())
  {
      return db.Licenses.Where(
          i =&gt; i.license == mylicense 
             // another filter          
          ).ToList();
  }
  </code></pre>
  
  <p>I have tried with ANY and CONTAINS, but I do not know how to do that with EF.</p>
  
  <p><strong>How to do this query in EF?</strong></p>