The DataSet Object

The DataSet object is the core component of ADO.NET. It is best described as a collection of disconnected recordsets that contain a hierarchy of table, row, and column data. A major difference between DataSet objects and a group of disconnected recordsets is that the DataSet keeps track of the relationships between tables internally. With a DataSet, the information requested is cached on the client and disconnected from the server. As a result, the DataSet has no knowledge of its data sources, so separate objects must pass information between the DataSet and the data source. Figure 9.5 graphically illustrates the hierarchy of information for the DataSet and its internal relationships.

Figure 9.5. DataSet hierarchy.

Using ...

Get Special Edition Using® Microsoft® ASP.NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.