c# select distinct code example
Example 1: c# linq select only unique values from list
var uniq = allvalues.GroupBy(x => x.Id).Select(y=>y.First()).Distinct();
Example 2: c# linq select only unique values from list
var uniqueCategories = repository.GetAllProducts()
.Select(p=>p.Category)
.Distinct();
Example 3: c# distinct dictionary
var temp = _context.PlayerStats.Where(T => T.allianceId == _surf).Select(T => T.guildId).Distinct();
var result = new Dictionary<string, string>();
foreach (var item in temp)
result[item] = _context.PlayerStats.FirstOrDefault(T => T.guildId == item).guildName;
return View(result);