O'Reilly logo

ADO.NET Programming in Visual Basic™ .NET by Bob Howell, Steve Holzner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The SqlClient and OleDbClient Classes

One of the design goals of ADO .NET was to phase out reliance on OLEDB, the database access technology based on COM+. Microsoft also realized that there are a large number of OLEDB providers that are well established. To accomplish this goal and retain backward compatibility with OLEDB providers, Microsoft created two branches to the data access classes. The OleDbClient set of classes can use any of the existing OLEDB providers except the ODBC OLEDB provider [1]. The SqlClient set of classes does not use OLEDB. It is a native ADO .NET data access technology. It is Microsoft’s goal to see third parties build other database-specific providers. There is already an Oracle client set of classes in beta. There ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required