I
ink
Hi all,
My company does things in a very specific way. Meaning we never query the
database directly, we always use Stored Procedures.
What i would like is to develop one data provider class for database
communication that can easily be added onto as time goes buy.
At the moment it needs to be able to import into SQL and Oracle, but in the
future DB2 and some others.
I want to allow the user of my Import Service to specify the connection
string and Database provider and then it should go of and do the importing
it needs to do.
The import Store Procedures will be the same on all databases.
i am not to sure how to go about this i found a news group post
http://www.dotnet247.com/247reference/msgs/31/156318.aspx
but again i am not sure if this is the best way of going about this.
The things i need to do is as follows.
Run Stored Procedures and return values from them.
Use Transactions to role back after errors.
if someone has seen a simple example of how best to do this i would be
grateful for any help.
Thanks,
ink
My company does things in a very specific way. Meaning we never query the
database directly, we always use Stored Procedures.
What i would like is to develop one data provider class for database
communication that can easily be added onto as time goes buy.
At the moment it needs to be able to import into SQL and Oracle, but in the
future DB2 and some others.
I want to allow the user of my Import Service to specify the connection
string and Database provider and then it should go of and do the importing
it needs to do.
The import Store Procedures will be the same on all databases.
i am not to sure how to go about this i found a news group post
http://www.dotnet247.com/247reference/msgs/31/156318.aspx
but again i am not sure if this is the best way of going about this.
The things i need to do is as follows.
Run Stored Procedures and return values from them.
Use Transactions to role back after errors.
if someone has seen a simple example of how best to do this i would be
grateful for any help.
Thanks,
ink