Chapter 5. Bringing Related Data Together

After completing this chapter, you will be able to:

  • Join multiple DataTable instances into a DataSet

  • Establish parent-child relationships between tables of data

  • Understand the types of table constraints available in ADO.NET

  • Build relationships that auto-correct linked rows when needed

The DataTable class provides ADO.NET’s core data-management functionality. But many of the tools that build and interact with DataTable content do so through a higher level of abstraction: the DataSet. Instead of relying on a single table’s worth of DataRows, a DataSet links multiple tables together, making it possible to generate data queries based on the relationships between the tables and their data.

In this chapter, the

Get Microsoft® ADO.NET 4 Step by Step 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.