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.