title: LINQ to SQL where ID not in some_list
body: <p>I'm trying to make a LINQ to SQL statement which filters results where the ID is <strong>not</strong> in some list of integers. I realise the .contains() method cannot be used in Linq to SQL but for the purposes of explaining what I'd like to do, here's what I'd like to do:</p>
  
  <pre><code>nextInvention = (from inv in iContext.Inventions
                      where !historyList.Contains(inv.Id)
                      orderby inv.DateSubmitted ascending
                      select inv).First&lt;Invention&gt;();
  </code></pre>
  
  <p>Any idea how I might go about doing this?</p>
  
  <p>Thanks!</p>