|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
Relationships in ADO.NET Datasets
A dataset can contain multiple tables, including tables that have an implicit relationship between them — tables with key fields in common. To take advantage of this implicit relationship, you use an ADO.NET DataRelation object. The following topics provide information about ADO.NET DataRelation objects, how to create them, and how to use them to work with data in related tables.
In This Section
- Introduction to DataRelation Objects
- Provides an overview of how datasets allow you to specify relationships between tables and how you can take advantage of these relationships.
- Creating DataRelation Objects with the XML Designer
- Explains how to use the XML Designer to add a DataRelation object to a dataset.
- DataRelation Class
- Provides reference information about the DataRelation class and links to topics about each member of the class.
- Introduction to Datasets
- Provides an overview of what ADO.NET dataset are, how they can by typed or untyped, what they are used for, and how they are structured.
- Introduction to Data Adapters
- Provides an overview of what data adapters are and what they are used for.
- Navigating a Relationship between Tables
- Describes how to write code that uses a DataRelation object to find related records in a data table.