distinct use in a dropdownlist

Question

I’m trying to get equal names off my dropdownlist, but they’re different id’s. I wanted where I would have to implant the code if it would be in the view, or in the controller somewhere else.

Data in the table:

And this is what the dropdownlist looks like

This is my view:

@Html.ValidationMessageFor(a => a.NomeProdutoId)
@Html.LabelFor(a => a.NomeProdutoId, "Escolher Produto:")
@Html.DropDownListFor(a => a.NomeProdutoId, new SelectList(ViewBag.Compra, "Id", "NomeProduto"))

That is the line of code that the ViewBag.Compra is pulling

public IList<Compra> Lista()
        {
            string hql = "select c from Compra c;";
            IQuery query = session.CreateQuery(hql);
            return query.List<Compra>();
        }

Answer 1

You can’t solve this just in the query?

select 
 Id, 
 NomeProduto 
from Compra c 
group by Id, NomeProduto
order by NomeProduto

Note: You may need to adjust the field of your Id...

Answer 2

Use the following code to get the expected result:

ViewBag.Compra = Lista()
                        .Select(x => new {Id = x.NomeId, NomeProduto = x.NomeProduto})
                        .Distinct();