ADO.NET supports a disconnected data access strategy through the use of DataSet objects. A DataSet is an in-memory cache of data that is data source independent. In effect, a DataSet provides a simple relational data store in memory. Although the source of data for a DataSet is usually a relational database, a DataSet can be populated from any source that’s accessible via an ADO.NET Data Provider. A DataSet has no inherent functionality to communicate with a data source; the Data Adapter element of the Data Provider is responsible for moving data between the DataSet and the data source. A DataSet can also be configured and populated manually and includes extensive support for importing XML data.

When working with data from a relational ...

Get C# for Java Developers now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.