How to: Configure Foreign-Key Constraints in a Dataset

By default, foreign-key constraints in a database are created in the generated dataset as a relation only, with the update and delete rules set to none.

You can change this behavior by editing the relationship in the dataset by using the Relation dialog box.

To configure the foreign-key constraints in a dataset

  1. Open your dataset in the Creating and Editing Typed Datasets.

  2. Open the Relation dialog box by double-clicking the relationship line that connects the data tables to the foreign-key constraint that is to be configured.

See Also

Tasks

Walkthrough: Saving Data from Related Data Tables (Hierarchical Update)

How to: Turn Off Constraints While Filling a Dataset

How to: Edit a Dataset

Concepts

Hierarchical Update Overview

Other Resources

Hierarchical Update