I am trying to list distinct values in a SelectListItem but it is not working. Any ideeas?
HazardSourceList = await _context.RiskAssessmentsMain.Where(s => s.OrgID == orgid).Select(s =>
new SelectListItem
{
Value = s.IdRA.ToString(),
Text = s.HazSource
}).Distinct().ToListAsync();