title: Linq List comparing and exclusion
body: <p>I have two <code>IQueryable&lt;&gt;</code> lists.  Say one is filled with objects of Class <code>Bottle</code> and the other is of type <code>Cup</code>.</p>
  
  <p>Both classes have a Guid called <code>DrinkID</code>.</p>
  
  <p>How would I take my <code>Bottle</code> list and find all the items in the <code>Cup</code> list that have a <code>DrinkID</code> that is NOT in the <code>Bottle</code> list?</p>
  
  <p>I am looking for something like this:</p>
  
  <pre><code>var bottles = _context.AllBottles;
  var cups = _context.AllCups.Where(cup =&gt; cup.DrinkID not in bottles.DrinkID);
  </code></pre>
  
  <p>I am using Linq to Entities. </p>