title: LINQ to Entities - DISTINCT on one column
body: <p>Is there a way to write following query with Linq to Entities (or Entity SQL, or Method Syntax, or any other way, but I would like to achieve it with Linq to Entities):</p>
  
  <pre><code>SELECT DISTINCT Column1
  FROM Table1
  </code></pre>
  
  <p>I'm using Entity Framework 4. Of course I don't want to use Distinct method that filters data after data is fetched from database.</p>
  
  <p>thanks,Pawel</p>