title: Syntax for LINQ to DataSets Row Filter in C#?
body: <p>I have two DataTables one is Primary Table and the rest is a sub table (I am using strongly typed dataset).</p>
  
  <p>Example</p>
  
  <p><strong>Employee Table</strong></p>
  
  <pre><code>Id   Name   City 
  1    AAA    NY 
  2    BBB    BB
  3    CCC    AA
  </code></pre>
  
  <p><strong>CityInitials Table</strong></p>
  
  <pre><code>CityInitial
  NY    
  FF  
  CC
  RR 
  RNF
  YOT
  DDD  
  </code></pre>
  
  <p>I have to select rows from employee table only when the 'city' in Employee table matches any of the CityInitials of
  CityInitials Table. i tried</p>
  
  <pre><code>var _filter = EmployeeTable.AsEnumerable().
  Select(x=&gt;x.Field&lt;string&gt;("City")).Contains
  (CityInitials.AsEnumerable().Field&lt;string&gt;("CityInitials").Select(row=&gt;row);
  </code></pre>
  
  <p>Please suggest what is the proper query to achieve the result?</p>