Performance - ODBC vs OLEDB vs SQL Providers

  • Thread starter Thread starter PeteZ
  • Start date Start date
P

PeteZ

I've come from a strong ODBC usage background (using DSN's on servers) and
am wondering whether I should start recommending OLEDB or SQL data providers
rather than ODBC

It seems that ODBC support was only provided in the .NET Framework Ver 1.1 -
should I be thinking ODBC as "old" legacy data provisioning or still keep
using it ?

..NET Applications on my plate may need to use MS SQL Server or Oracle
databases.

Anyone got any comments on this ?

- peteZ
 
I'd definitely vote for the managed SQL provider for the MS SQL server
connectivity because it is completely managed implementation that does not
use neither ODBC nor OLEDB underneath.
 
Second and thrided. I dont have any actual figures to hand but I have
benchmarked this in the past and they are FAR faster. If needs be try and
create a middleware layer to your app that takes the data interfaces
(IDataReader etc.) to do your business logic, that way you can create
another layer beneath that that sets up your connection etc. that is db
specific.

HTH
Kieran
 
It seems that ODBC support was only provided in the .NET Framework Ver
1.1 -
should I be thinking ODBC as "old" legacy data provisioning or still keep
using it ?
Click to expand...
.NET Applications on my plate may need to use MS SQL Server or Oracle
databases.
Click to expand...

You can use the .Net ODBC Provider also with .Net framework 1.0, but you
have to download and install it separately, it was not on time to include it
in VS.Net 2002.

Said that, it is recommended to use the managed .Net data providers for
Oracle and SQL Server. If you are interested in database interoperability,
take a look at the IDBXXX interfaces (IDBConnection instead of
OracleConnection, SQLConnection). Notice also that parameter markers and
ODBC syntax may not be supported.

HTH,

Carlos Quintero
 
Back
Top