System.Data.DataSet (class)

System.Data.DataSet is an in-memory cache of relational and persistent data and a major component of the ADO.NET architecture.

Because a DataSet stores data in memory, it is independent from a specific data source and allows for ADO.NET's disconnected programming model.

A DataSet object consists of multiple System.Data.DataTables that are possibly related in parent-child relationships through System.Data.DataRelation objects.

It is possible to define constraints on the tables.

A DataSet might be connected to a persistent data source with a System.Data.Common.DataAdapter which allows to persist the data of a DataSet to a data source.

Important properties:

• SelectCommand
• InsertCommand
• UpdateCommand
• DeleteCommand

Fill() uses the value of SelectCommand to transfer data into a DataSet.