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()