title: LINQ to SQL distinct records
body: <p>I want to get distinct records by using LINQ not on the base of Id but on other field of the table i.e. date.
  The table schema is ID (Unique Identifier),date (dateTime), Desc varachar(50)</p>
  
  <p>Records are like :
  1st row:</p>
  
  <pre><code>Id 61DDF6A2-E5B7-4E88-91FE-5C63EF8E15D8
  date 8/1/2010
  Desc Abc
  </code></pre>
  
  <p>1st row:</p>
  
  <pre><code>Id 61DDF6A2-E5B7-4E88-91FE-5C63EF8E15D8
  date 8/1/2010
  Desc Abc
  </code></pre>
  
  <p>2nd row:</p>
  
  <pre><code>Id 61DDF6A2-E5B7-4E88-91FE-5C63EF8E15B1
  date 8/1/2010
  Desc Abc
  </code></pre>
  
  <p>3rd row:</p>
  
  <pre><code>Id 61DDF6A2-E5B7-4E88-91FE-5C63EF8E15D8
  date 8/1/2010
  Desc Xyz
  </code></pre>
  
  <p>4th row:</p>
  
  <pre><code>Id 61DDF6A2-E5B7-4E88-91FE-5C63EF8E15D9
  date 8/3/2010
  Desc AAAA
  </code></pre>
  
  <p>5th row:</p>
  
  <pre><code>Id 51DDF6A2-E5B7-4E88-91FE-5C63EF8E15D9
  date 8/3/2010
  Desc AAAA
  </code></pre>
  
  <p>Now what i want is distinct records on the base of date</p>
  
  <p>Required result is like :</p>
  
  <pre><code>id 61DDF6A2-E5B7-4E88-91FE-5C63EF8E15D8
  date 8/1/2010
  Desc Abc
  
  Id 61DDF6A2-E5B7-4E88-91FE-5C63EF8E15D9
  date 8/3/2010
  Desc AAAA
  </code></pre>