SubSonic.Query.QueryCommand - ExecuteNonQuery requires an open and available Connection using

[luisvsilva]

Using Multiple Providers. To reproduce exception:

IDataProviderProvider = ProviderFactory.GetProvider("BlahProvider");
new SubSonic.Query.QueryCommand(
                   "Delete from foo", Provider
               ).ToDbCommand().ExecuteNonQuery();

This works fine:

SubSonic.Query.QueryCommand query = new  SubSonic.Query.QueryCommand( "Delete from foo",Provider);
Provider.ExecuteQuery(query);

StackTrace:

System.InvalidOperationException was unhandled
Message=ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
Source=System.Data
StackTrace:
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()