O'Reilly logo

Essential ADO.NET by Bob Beauchemin

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

3.1. .NET Data Providers and the Connected Model

As mentioned in Chapter 2, the connected part of ADO.NET features data providers, a new model for using databases. Microsoft ships two data providers with .NET: the SqlClient data provider for SQL Server 7.0 and later, and the OleDb data provider for OLE DB data sources. A data provider for ODBC data sources is available as a Microsoft Web release, as are the SqlXml managed data classes discussed in Chapter 7; other specialized providers from Microsoft, DataDirect Technologies (formerly MERANT DataDirect), and others will be available by the time you read this. APIs to abstract database access started with ODBC and include OLE DB, ADO (a library that sits atop OLE DB), and JDBC. They all abstract ...

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