Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

AdapterSet

Writing code to submit changes for multiple related tables using a DataSet and DataAdapters is a nontrivial process, as Chapter 11 illustrates. That doesn’t have to be the case. There are basic patterns to follow—inserts are top-down, deletes are bottom-up, and so on. If you build logic to submit changes to related tables in one application, you’ll find that you can re-use most of that logic in other applications. You might even be able to generalize that updating logic based on the relationships and between the tables in your database.

Those database relationships might have corresponding DataRelations in the DataSet, and each DataTable will have a corresponding DataAdapter. In such cases, the generalized logic could be expressed by ...