how to get distinct records in dropdownlistfor form database in asp.net mvc5

Asked Mar 12 '16 at 07:32

Active Mar 12 '16 at 09:24

Viewed 448 times

I am populating a dropdownlist from database. Table has some duplicate records in it. I want the dropdownlist to have distinct results. I have tried following code.

model.Specialization = _SpecializationRepository.GetAll().Distinct().Select(x =>
    new SelectListItem
    {
       Value = x.SpecializationId.ToString(),
       Text = x.Description
    });

Its taking all the rows from database and displaying it in dropdownlist.

edited Mar 12 '16 at 09:24

juvchan

6,113
2
22
35

asked Mar 12 '16 at 07:32

Secret Star

what about distinct(l = >l.somevalue) – Alper Tunga Arslan Mar 12 '16 at 08:44
it's not taking any value – Secret Star Mar 12 '16 at 09:44
Take a look at [this](http://stackoverflow.com/questions/489258/linqs-distinct-on-a-particular-property) – GregoryHouseMD Mar 12 '16 at 12:01
Its giving me this error.....Cannot convert lambda expression to type 'System.Collections.Generic.IEqualityComparer' because it is not a delegate type – Secret Star Mar 12 '16 at 12:16

how to get distinct records in dropdownlistfor form database in asp.net mvc5

0 Answers0