Understanding the ADO.NET DataSet

The DataSet class is a member of the System.Data namespace. It represents the first of the two major components of the ADO.NET architecture you learned about on Day 1, “ADO.NET In Perspective,” the other being the .NET Data Providers. Its major attributes include the following:

  • It is XML-based.

  • It is an in-memory cache of data that is not backed by a file or data store—it is disconnected.

  • It is independent of a data store and cannot communicate with one by itself.

  • It can store data in multiple tables from multiple data stores that can be related through foreign key relationships.

  • It stores multiple versions of the data for each column and for each row in each table.

  • It can be serialized with full fidelity to XML for ...

Get Sams Teach Yourself ADO.NET in 21 Days 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.