Doesn't auto-dispose connection & exception occurs when connection opened inside command

[rshenton]

Issue description

-using statement on connection should auto-dispose connection, but doesn't -> (should override Dispose & call Close)
-should allow connection to be opened in command?

Example code

//THIS WORKS AND CLOSES CONNECTION
var con = new Snowflake.Data.Client.SnowflakeDbConnection();
con.ConnectionString = "CONNECTION_STRING_HERE";
try
{   
    con.Open();

    using (var cmd = new Snowflake.Data.Client.SnowflakeDbCommand(con))
    {
        //cmd.CommandType = CommandType.Text;
        cmd.CommandText = query;

        using (var da = new Snowflake.Data.Client.SnowflakeDbDataAdapter(cmd))
        {
            da.Fill(dt);
        }
    }
}
finally
{
    con.Close();
}

//THIS DOESN'T WORK AND FAILS TO CLOSE CONNECTION
using (var con = new Snowflake.Data.Client.SnowflakeDbConnection())
{
    con.ConnectionString = "CONNECTION_STRING_HERE";
                
    using (var cmd = new Snowflake.Data.Client.SnowflakeDbCommand(con))
    {
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = query;

        con.Open();
        using (var da = new Snowflake.Data.Client.SnowflakeDbDataAdapter(cmd))
        {
            da.Fill(dt);
        }
    }

    //con.Close(); //This line doesn't matter since exception happens above and gets bypassed
}

Configuration

Snowflake.Data(1.0.4)
netcoreapp2.0

[howryu]

Thanks for your report. auto-dipose is a known issue, we have some other resources are not auto-dispose, #20.

For the second one, I will check why it is not working.