title: Find intersecting DataRows in a List of DataTables
body: <p>I have a List. I would like to filter through all the rows in the list of tables to find all the rows that are in every datatable in the list.</p>
  
  <p>If possible,  the compare needs to be on the "ID" column that is on every row.</p>
  
  <p>I have tried to solve this with Linq but got stuck. This is what I have so far:</p>
  
  <pre><code>List&lt;DataTable&gt; dataTables = new List&lt;DataTable&gt;();
  
  // fill up the list
  List&lt;DataRow&gt; dataRows = 
      dataTables.SelectMany(dt =&gt; dt.Rows.Cast&lt;DataRow&gt;().AsEnumerable()).
      Aggregate((r1, r2) =&gt; r1.Intersect(r2));
  </code></pre>
  
  <p>Any suggestions? </p>