In order to have better control on executiion of data objects like Connection, Command, DataAdapater and also to support portability, I have a class model in place that implements the IDBxxxx interfaces and delegates the call to the underlying Provider objects. for e.g I have a GenericDBConnection class that implements the IDBConnection interface and delegates the calls to either a SqlConnection or a OracleConnection depending on the connection parameters. I have similar implementation for IDbCommand,
Read More...