public IEnumerable<Player> GetByGame(int gameId) { using (var context = new BolfTrackerContext()) { var players = context.Shots.Where(shot => shot.Game.Id == gameId).Select(shot => shot.Player).Distinct().ToList(); return players; } }