---
title: "How to find select distinct Address in Entity Framework"  
description: "How to find select distinct Address in Entity Framework"  
author: "Simond Gear"  
published: 2016-03-19  
updated: 2016-03-19  
canonical: https://www.mindstick.com/forum/34065/how-to-find-select-distinct-address-in-entity-framework  
category: "asp.net mvc"  
tags: ["c#", "asp.net", "mvc", "entity framework"]  
reading_time: 1 minute  

---

# How to find select distinct Address in Entity Framework

Hi All,\
I want to [access](https://www.mindstick.com/articles/12994/how-foreigners-can-access-blocked-websites-in-china) all [distinct](https://www.mindstick.com/forum/159558/why-c-sharp-linq-distinct-doesn-t-work) 'Address' in [Employee](https://www.mindstick.com/articles/85431/remote-employee-training-tips-tricks) Table. My [code](https://yourviews.mindstick.com/view/85458/alan-turing-the-mastermind-behind-cracking-the-enigma-code-during-world-war-ii) is below:\

```
SELECT DISTINCT Address FROM Employee
```

But i am not get correct [output](https://www.mindstick.com/interview/34427/explain-the-output-in-angular) .Can any one give me a solution.

Thank you.\

## Replies

### Reply by Anupam Mishra

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()**.


---

Original Source: https://www.mindstick.com/forum/34065/how-to-find-select-distinct-address-in-entity-framework

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.