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