O'Reilly logo

Special Edition Using C# by NIIT

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

Data Providers

ADO mostly uses OLE DB objects to connect to a data source. In ADO.NET, the Managed Provider objects connect to a data source. ADO.NET Managed Providers provide a multi-tiered, disconnected model for application development. Data Providers help create connections between a DataSet and a data source.

Introduction to Data Providers

Data Providers link the DataSet to the data source and act as the intermediary between the two. The data source can be a SQL Server database or even XML documents. A Data Provider has three main components:

  • DataAdapter— These components are used for communication between the data source and the DataSet objects. The DataAdapter object is responsible for retrieving the data and loading the DataSet.

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