public SQLResult Query(PreparedStatement stmt)
{
    try
    {
        var connection = new MySqlConnection(_connectionInfo.ConnectionString); 
        connection.Open();

        using MySqlCommand cmd = connection.CreateCommand();

        cmd.CommandText = stmt.CommandText;
        foreach (var parameter in stmt.Parameters)
            cmd.Parameters.AddWithValue("@" + parameter.Key, parameter.Value);

        return new SQLResult(cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection));
    }
    catch (MySqlException ex)
    {
        HandleMySQLException(ex, stmt.CommandText, stmt.Parameters);
        return new SQLResult();
    }
}
--------------------------
public class SQLResult
{
    MySqlDataReader _reader;

    public SQLResult() { }

    public SQLResult(MySqlDataReader reader)
    {
        _reader = reader;
        NextRow();
    }

    ~SQLResult()
    {
        _reader = null;
    }   

    public bool NextRow()
    {
        if (_reader == null)
            return false;

        if (_reader.Read())
            return true;

        _reader.Close();
        return false;
    }
}

public class SQLResult : IDisposable
{
    MySqlDataReader _reader;

    public SQLResult() { }

    public SQLResult(MySqlDataReader reader)
    {
        _reader = reader;
        if (!NextRow())
        {
            Dispose();
        }
    }

    public bool NextRow()
    {
        return _reader.Read();
    }

    public void Dispose()
    {
        if (_reader != null)
        {
            _reader.Close();
            _reader = null;
        }
    }
}