LINQ to Entities - DISTINCT on one column

Question

LINQ to Entities - DISTINCT on one column

entity-framework linq linq-to-entities

Question

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):

SELECT DISTINCT Column1
FROM Table1

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.

thanks,Pawel

dragonfly

Popular Answer

For distinct by column, use this extension:

public static IEnumerable<T> DistinctBy<T, TKey>(this IEnumerable<T> items, Func<T, TKey> property)
{
    return items.GroupBy(property).Select(x => x.First());
}

Carl Prothman

View more on Stack Overflow

okrumnow · Accepted Answer · 12/12/2011 12:34:11 PM

Use something like

db.Table1.Select(t => t.Column1).Distinct()

As Munim mentioned in his comment, the Distinct() method does add the DISTINCT to the query. So resulting SQL query will be

SELECT [Distinct1].[Column1] AS [Column1]
  FROM ( SELECT DISTINCT 
    [Extent1].[Column1] AS [Column1]
    FROM [dbo].[Table1] AS [Extent1]
  )  AS [Distinct1]

LINQ to Entities - DISTINCT on one column

Question

Fastest Entity Framework Extensions

Accepted Answer

Popular Answer

Performance

Expression Evaluator

Related