szamil
szamil

Reputation: 684

DataSet Cascade Update

I have ASP.NET application that uses DataSets. All required relations 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.

Upvotes: 0

Views: 659

Answers (1)

newdayrising
newdayrising

Reputation: 3802

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?

Upvotes: 1

Related Questions