||Transparent Database Access with ADO.NET|
|Subject:||Can't be done|
|Still can't do this like JDBC. As already pointed out, parameter binding changes between data providers. Another one that will bite you is transactions. In SqlClient, you need to bind the transaction to each command. In ODP.NET command doesn't even have the methods to do this. According to their documentation, transactions are per connection and don't work like SqlClient. If you're doing select * from table where without bound parameters or transactions, you're ok. If not, you still need to recode for each DB type.|
Showing messages 1 through 2 of 2.