var temp = _context.PlayerStats.Where(T => T.allianceId == _surf).Select(T => T.guildId).Distinct(); var result = new Dictionary(); foreach (var item in temp) result[item] = _context.PlayerStats.FirstOrDefault(T => T.guildId == item).guildName; return View(result);