title: LINQ to remove duplicate rows from a datatable based on the value of a specific row
body: <p>I have seen the following solution used for removing duplicate rows in a <code>DataTable</code> using <code>LINQ</code>:</p>
  
  <p>Say if we have a <code>DataTable</code> with duplicate rows called <code>dt</code>, then the following statemend apparently does the job:</p>
  
  <pre><code>IEnumerable&lt;DataRow&gt; uniqueContacts = dt.AsEnumerable().Distinct(DataRowComparer.Default);
  </code></pre>
  
  <p>But this is only removing duplicate rows that are identical. What I want to do is to remove all the rows that have duplicate values of a specific row.</p>
  
  <p>E.g. If we have a datatable with a row called "Email", how can we remove all the rows that have the same email value?</p>