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();