Understanding Relations
Tags:
ADO.NET
, IDE
, 2003
, Beginning
Relations take two complex type elements (which Microsoft's documentation refer to as tables ... just like you would find tables in a database or ADO.NET DataSet) and create relations between them. Thse relations serve two purposes. First, when the XML Schema is used to generate a Dataset, the relation allows you to look up all the records from a child table that relate to a record in the parent table. Additionally, relations allow you to enforce referential integrity in your Dataset. This video explains the creation of relations, including the Edit Relations dialog, as well as how to edit and delete relations and keys.