I am unable to get a distinct list of 'Order' from my Lambda query. Even though am using the keyword Distinct() it is still retuing repeated select list item.
public ActionResult Index()
{
var query = _dbContext.Orders
.ToList()
.Select(x => new SelectListItem
{
Text = x.OrderID.ToString(),
Value = x.ShipCity
})
.OrderBy(y => y.Value);
ViewBag.DropDownValues = new SelectList(query, "Text", "Value");
retu View();
}
Any suggestions please?
