DataSet Cascade Update

I have ASP.NET application that uses DataSets. All required rela开发者_运维技巧tions are already set in the database and in the DataSet.

How can I update primary key in parent table and be sure that all fields in other tables related to that key are updated too?

If I perform Adapter.Update(...), the related tables stay untouched.

---

You should not ever need to update a primary key value. It's a unique identifier for a row and should be reliable to be used as such.

What are you actually trying to accomplish and maybe we can suggest an alternative approach?