Oledb or Odbc
-
can anyone pls say in what kind of a scenario can i go for System.Data.Oledb and System.Data.Odbc. Is there any difference in their performance. will it suit well for Oracle. ----------------------------------------------------------------
where there is a will there is a way
-
can anyone pls say in what kind of a scenario can i go for System.Data.Oledb and System.Data.Odbc. Is there any difference in their performance. will it suit well for Oracle. ----------------------------------------------------------------
where there is a will there is a way
Hi, generally those are two different abstraction layers mainly doing the same thing. When trying to decide which one to use you should at first look for which one a driver for the target db is available. In the case of Oracle you could use both. If I remember correctly OleDb was faster, but this only matters if you fetch large amounts of data from the db. If you know you are using Oracle and you also know you will never switch the database engine than have a look at ODP.NET[^]. It's an implementation of the common ADO.Net interfaces which comes directly from Oracle and is (naturally) faster than the other two. It also has some more Oracle specific functionalities. The biggest drawback is that you can only access Oracle with it and nothing else. Robert