Chapter 6. Modeling a Database by Using DataSets and DataRelations

After completing this chapter, you will be able to:

  • Create Typed and Untyped DataSets.

  • Add DataTables to DataSets.

  • Add DataRelations to DataSets.

  • Clone and copy DataSets.

Beginning with this chapter, we'll move away from the Microsoft ADO.NET Data Providers to examine the objects that support the manipulation of data in your applications. We'll start with the DataSet, the memory-resident structure that represents relational data.

Understanding DataSets

In the Microsoft .NET Framework, a DataSet is an in-memory cache of data. The structure of the DataSet is essentially the same as that of a relational database, as shown in the following figure.

ADO.NET supports two distinct kinds of DataSets: ...

Get Microsoft® ADO.NET 2.0 Step by Step, 2nd Edition now with O’Reilly online learning.

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