Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

Show:
© 2015 Microsoft