asp.net 4.5 MVC SQL using distinct

Question

@foreach (var item in Model) { string mytown = item.town.*enter distinct here* <option value="@mytown"> @mytown</option>

This selects all the town names in my database and I've got it to display in a drop down menu.

How can I change this so that when it's displaying the town names, it will only show each town name once.

For example, if I have 3 londons in the database it will show all 3 londons in the drop down menu. I want it to only show 1 london

FYI: Sorry this may seem like a repost but I posted the wrong code earlier

Its a repost.. but it doesn't change the answer from your previous question. Use Distinct. — Simon Whitehead
– Simon Whitehead, Commented Dec 12, 2013 at 4:28

maxspan · Accepted Answer · 2013-12-12 04:38:24Z

2

myCollection.Select(x => x.Name).Distinct().ToList();

answered Dec 12, 2013 at 4:38

maxspan

14.3k16 gold badges79 silver badges115 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RollerCosta · Accepted Answer · 2013-12-12 05:48:58Z

1

As far as my understanding, you can't do this if you are using ID as value.

Say

ID | Value
1    Landon
2    Landon
3    Landon
4    Los Angeles

Better way you can achieve this is by using LINQ. Get the list from the database then filter it in the controller towns.Where(x => x.Name == x.Name.Distinct());

further Inside controller action

ViewBag.towns = new SelectList(towns.Where(x => x.Name == x.Name.Distinct()).ToList(), "Value", "Text");

Inside view

 @Html.DropDownListFor(x => x.SelectedTown, new SelectList(ViewBag.towns, "ID", "Name", Model.SelectedTown))

edited Dec 12, 2013 at 5:48

answered Dec 12, 2013 at 5:39

RollerCosta

5,23410 gold badges57 silver badges71 bronze badges

Comments

Aniket Inge · Accepted Answer · 2013-12-12 04:39:23Z

0

Why not convert it to a HashSet<string>()?

var hs = new HashSet<string>(Model);

given, Model is IEnumerable<string> ?

Or, do that in the controller, by converting the List<T> to HashSet<T> and then pass it as an IEnumerable<T> to the model.

or this one:

from y in Model.Distinct() select y

edited Dec 12, 2013 at 4:39

answered Dec 12, 2013 at 4:33

Aniket Inge

25.9k5 gold badges54 silver badges80 bronze badges

Collectives™ on Stack Overflow

asp.net 4.5 MVC SQL using distinct

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related