Developing XML Web Services and Server Components with Visual C#™ .NET and the .NET Framework, Exam Cram™ 2 (Exam 70-320) By Amit Kalani, Priti Kalani
Table of Contents
Chapter 2. Consuming and Manipulating DataSets
ADO.NET is the overall name for the set of classes (spread across a number of namespaces, including System.Data, System.Data.Common, System.Data.SqlTypes, System.Data.SqlClient, and System.Data.OleDb) that the .NET Framework provides for working with data in relational databases. The ADO.NET object model is broken up into two distinct sets of objects data provider objects and DataSet objects because the .NET Framework separates the task of using data from the task of storing data.
The DataSet object provides a memory-resident, disconnected set of objects that you can load with data. A data provider object handles the task of working directly with data sources. One of the provider objects, the DataAdapter object, serves as a conduit between the two sets of objects. By using a DataAdapter object, you can load data from a database into a DataSet object and later save changes back to the original data source. Figure 2.1 shows schematically how these two sets of objects fit together in the overall ADO.NET architecture.
