title: Distinct in Linq based on only one field of the table
body: <p>I am trying to use .distinct in Linq to get result based on one field of the table (so do not require a whole duplicated records from table).</p>
  
  <p>I know writing basic query using distinct as followed:</p>
  
  <pre><code>var query = (from r in table1
  orderby r.Text
  select r).distinct();
  </code></pre>
  
  <p>but I need results where <code>r.text</code> is not duplicated.</p>