Entity Framework 6 - Knowledge Base (KB)

Entity Framework chooses a unique name

How can I do this ...SQL... query with ...Entity Framework...? ...SELECT DISTINCT NAME FROM TestAddresses

Entity framework is unique.

I have a List of objects that some of them have the same Ids, so I would like to remove those elements that are duplicated. ...I tried with something like this:...List<post> posts = postsFromDatabase.Distinct().ToList(); ...But it doesn't work!...So I wro...

What is the best way to use IEqualityComparer to return distinct values?

I have a L2E query that returns some data that contains duplicate objects. I need to remove those duplicate objects. Basically I should assume that if their IDs are the same then the objects are duplicate. I've tried ...q.Distinct()..., but that still ret...

Issue with Entity Framework returning distinct records

I have a PC Enity which have some Properties , I would like to return a list of distinct Object (PC or Complex Type or whatever ) based on a property in order to bind it to server controls like DropDownList . And Because my method located in BLL I can't r...

Linq to Entities Select Distinct

I'm not sure what I'm missing but I've been thrashing at this one all afternoon....I have a Sql Server view of Companies which looks like this:...CompanyId varchar(30) NOT NULL CompanyName varchar(100) NOT NULL CompanyPriority int NULL ConfigItem int NOT ...