public List <Player> GetPlayersByPosition(int node) { var connection = _databaseService.GetConnection(); var players = connection.Query <Player>( "SELECT * FROM players WHERE node = @node", new { node }); connection.Close(); return(players.Where(x => _socketRepository.IsPlayerOnline(x.Id)).ToList()); }