This is my code.. IEnumerable<SelectListItem> Categorylist = db.Threads.AsEnumerable().Select(c => new SelectListItem { Value = c.Category, Text = c.Category }).ToList(); // how can i add distinct to my query ...