This documentation is archived and is not being maintained.

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.

Related Topics

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.