Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to find select distinct Address in Entity Framework

Simond Gear 2297 19 Mar 2016

Hi All,

I want to access all distinct 'Address' in Employee Table. My code is below:

SELECT DISTINCT Address FROM Employee

But i am not get correct output .Can any one give me a solution.

Thank you.

Simond Gear

Other

1 Answers

Anupam Mishra 19 Mar 2016

Hi Simond,

you try this:

var res = (from Add in context.Employee

select Add .Address).Distinct();

It will returns IEnumerable<string>. you can convert List<string> by adding .ToList().

advertising