Submitting Hierarchical Changes
When you modify data in multiple levels of a hierarchical DataSet, you will face two challenges when you submit those changes to your database. Let’s take a look at these scenarios.
Submitting Pending Insertions and Deletions
Say that you’re dealing with a hierarchy that contains orders and order details. The application you’ve built is an order entry system. The user has made a number of changes to the data and now wants to submit those changes to your database. The modified data in the DataSet contains new orders and new order details. The DataSet also contains orders and order details that are marked for deletion.
The challenge is to submit these changes in the proper order to comply with the referential integrity ...
Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
