Entity Framework select distinct name

c# linq entity-framework distinct
patrick picture patrick · Dec 27, 2010 · Viewed 207.3k times · Source

How can I do this SQL query with Entity Framework? 

SELECT DISTINCT NAME FROM TestAddresses

Answer

py2020 picture py2020 · Dec 27, 2010

Using lambda expression..

 var result = EFContext.TestAddresses.Select(m => m.Name).Distinct();

Related questions

Entity Framework. Delete all rows in table

How I can quickly remove all rows in table using Entity Framework? I am currently using: var rows = from o in dataDb.Table select o; foreach (var row in rows) { dataDb.Table.Remove(row); } dataDb.SaveChanges(); However, it takes a …

Read More
Linq Syntax - Selecting multiple columns

This is my Linq Syntax which I am using to my entity model IQueryable<string> objEmployee = null; objEmployee = from res in _db.EMPLOYEEs where (res.EMAIL == givenInfo || res.USER_NAME == givenInfo) select res.EMAIL; How can I select …

Read More
Unable to create a constant value of type Only primitive types or enumeration types are supported in this context

I am getting this error for the query below Unable to create a constant value of type API.Models.PersonProtocol. Only primitive types or enumeration types are supported in this context ppCombined below is an IEnumerable object of PersonProtocolType, which …

Read More