Performance - ODBC vs OLEDB vs SQL Providers

[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

 

[Dmitriy Lapshin [C# / .NET MVP]]

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.

 

[bob]

managed SQL providers in should offer improved performance..

 

[Kieran Benton]

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

 

[Carlos J. Quintero]

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.

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