title: LINQ Select distinct on DataTable not working
body: <p>I have the following datatable - Let's say called <code>MyTable</code>:</p>
  
  <pre><code>Col1:    Col2:    Col3:    Col4:
  1        abc      def      &lt;null&gt;
  2        abc      def      ghi
  1        abc      def      &lt;null&gt;
  3        abc      def      &lt;null&gt;
  1        abc      def      &lt;null&gt;
  </code></pre>
  
  <p>And I'm trying to get the distinct rows:</p>
  
  <pre><code>Col1:    Col2:    Col3:    Col4:
  1        abc      def      &lt;null&gt;
  2        abc      def      ghi
  3        abc      def      &lt;null&gt;
  </code></pre>
  
  <p>I tried the following LINQ statement:</p>
  
  <pre><code>MyTable = (From dr As DataRow In MyTable Select dr).Distinct.CopyToDataTable
  </code></pre>
  
  <p>But it's returning the original datatable with the repeated rows back to me.</p>
  
  <p>What am I doing wrong AND how can I get my desired output??</p>