title: LINQ to SQL select distinct from multiple colums
body: <p>I'm using LINQ to SQL to select some columns from one table. I want to get rid of the duplicate result also.</p>
  
  <pre><code>Dim customer = (From cus In db.Customers Select cus.CustomerId, cus.CustomerName).Distinct
  </code></pre>
  
  <p>Result:</p>
  
  <ul>
  <li>1   David</li>
  <li>2   James</li>
  <li>1   David</li>
  <li>3   Smith</li>
  <li>2   James</li>
  <li>5   Joe</li>
  </ul>
  
  <p>Wanted result:</p>
  
  <ul>
  <li>1   David</li>
  <li>2   James</li>
  <li>3   Smith</li>
  <li>5   Joe</li>
  </ul>
  
  <p>Can anyone show me how to get the wanted result? Thanks.</p>