title: Excluding large List<int> from LINQ to Entities query
body: <p>I have a List containing a high number of items - up to 10,000.</p>
  
  <p>I am looking for the most efficient way to exclude these from an IQueryable/List.</p>
  
  <p>Due to the complexity of the process involved in obtaining this list of Ids, it isn't possible to do this within a query.</p>
  
  <p>The example below has an extremely high overhead and wondered if anybody might be able to explain possible reasons for this and if there's a better way to achieve this?</p>
  
  <pre><code>results = from q1 in results 
    where excludedRecords.All(x =&gt; x != q1.ItemId)
    select q1;
  </code></pre>