title: Filter a DataTable where the table does not contain items in List<string>
body: <p>I am having a few problems quering a DataSet.Tables[0] and removing rows that do not meet the critira of a List.</p>
  
  <pre><code>//This is my list
  var values = new List&lt;string&gt; {"Test", "Test2"};
  
  // Now I just query the DataSet for anything that doesnt match this list
  var query = from x in ds.Tables[0].AsEnumerable()
              from b in values
              where !x.Field&lt;string&gt;("ColumnName").Contains(b)
              select x;
  </code></pre>
  
  <p>This works and returns the results but it is returning 2 x sets of the same rows (I assume because there is no join).</p>
  
  <p>How can I just get Distinct values of these rows?</p>