Hardly.SqlController.ExecuteReader C# (CSharp) Method

        static void ExecuteReader(string sql, object[] vars, List<object[]> resultsList)
        {
            Log.debug("Sql reader: " + sql);

            using(MySqlConnection connection = new MySqlConnection(connectionString)) {
                using(MySqlCommand command = new MySqlCommand(sql, connection)) {
                    SetParameters(command, vars);
                    connection.Open();
                    using(MySqlDataReader reader = command.ExecuteReader()) {
                        if(reader.HasRows) {
                            while(reader.Read()) {
                                object[] values = new object[reader.FieldCount];

                                reader.GetValues(values);
                                resultsList.Add(values);
                            }
                        }
                    }
                }
            }
        }