title: SQL "not in" syntax for Entity Framework 4.1
body: <p>I have a simple issue with Entity Framework syntax for the "not in" SQL equivalent.  Essentially, I want to convert the following SQL syntax into Entity Framework syntax:</p>
  
  <pre class="lang-sql prettyprint-override"><code>select  ID
  from    dbo.List
  where   ID not in (list of IDs)
  </code></pre>
  
  <p>Here is a method that I use for looking up a single record:</p>
  
  <pre class="lang-cs prettyprint-override"><code>public static List GetLists(int id)
  {
      using (dbInstance db = new dbInstance())
      {
          return db.Lists.Where(m =&gt; m.ID == id);
      }
  }
  </code></pre>
  
  <p>Here is a pseudo-method that I want to use for this:</p>
  
  <pre class="lang-cs prettyprint-override"><code>public static List&lt;List&gt; GetLists(List&lt;int&gt; listIDs)
  {
      using (dbInstance db = new dbInstance())
      {
          return db.Lists.Where(**** What Goes Here ****).ToList();
      }
  }
  </code></pre>
  
  <p>Can anyone give me pointers as to what goes in the <code>Where</code> clause area?  I read some forums about this and saw mention of using <code>.Contains()</code> or <code>.Any()</code>, but none of the examples were a close enough fit.</p>