Sql/OleDb/Odbc/ CommandBuilder

[Tim Bücker]

Hello.

I am using the factory pattern to switch between different managed
providers.
For the DataAdapter, Command and Connection objects everything is working
fine due to the interfaces
IDbDataAdapter, IDbCommand and IDbConnection.

But how can I encapsulate OleDbCommandBuilder, SqlCommandBuilder, ... as
there is no interface?
Any ideas? Is it possible at all?

Thanks for your thoughts and help,
Tim.

 

[Simon Smith]

What I've always done it to have my oen class called e.g. DB which is
given sql etc to run. A factory creates different subclasses of it - SqlDB,
OdbcDB, etc.

Simon Smith
simon dot s at ghytred dot com
http://www.ghytred.com/NewsLook - Usenet for Outlook