This section, deals with the representation of database data, in a disconnected, memory-resident database by taking advantage of ADO. The Data Set, which is an in-memory cache of data retrieved from a database, is a major component of the ADO. The Data Set consists of a collection of Data Table objects that can be related to each other with Data Relation objects.Data integrity can be enforced in the Data Set by using the Unique Constraint and Foreign Key Constraint objects.developer uses Data Set and Data Reader to fetch data from the data source while developing application.But most of them don’t know exactly what are the main difference between Data Set and Data Reader and what to use and when to use out of these two.While Data Table objects contain the data, the Data Relation Collection allows navigating through the table hierarchy.

The following section will show you how to test updating, inserting, and deleting the data.

We can set up Data Relations between these tables within the Data Set.

The Data Adapter Object allows us to populate Data Tables in a Data Set.

As one row at a time is stored in memory in Data Reader it increases application performance and reduces system overheads while there is more system overheads in Data Set as it fetches all the data from the datasource at a time in memory.

is a connected architecture: The data is available as long as the connection with database exists while Data Set is a disconnected architecture that automatically opens the connection, fetches the data into memory and closes the connection when done."If you like my work; you can appreciate by leaving your comments, hitting Facebook like button, following on Google , Twitter, Linked in and Pinterest, stumbling my posts on stumble upon and subscribing for receiving free updates directly to your inbox .