ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  Transparent Database Access with ADO.NET
Subject:   Can't be done
Date:   2003-03-02 18:06:20
From:   anonymous2
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.

1 to 1 of 1
  1. Can't be done
    2003-04-30 22:43:29  anonymous2 [View]

    • Can't be done
      2003-05-02 09:47:01  anonymous2 [View]

1 to 1 of 1