Re: Transactions in ADO.Net 2 strongly-typed datsets.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Sahil,

Thank you for your detailed reply. However, I think there may be a
slight misunderstanding as to what we've done so far. The Group object
is NOT in a dataset with a relation to the Group members. They ARE
related in SQL, but not in a dataset. The Group object loads its data
and sets its properties. One of the properties is a single,
strongly-typed datatable of the Group Member data.

When we do an add, the Group object will add the Group and then call
the update to the dataset of members. The same would be true of
update. For delete, our db cascading will take care of deleting all
members if a group is deleted.

During these procedures, I want to wrap the object's add/update/delete
steps in a single transaction. One of these steps is the .UPDATE call
to the dataset. Is this possible? Am I being clear or just confusing
the issue more? :o)

Thanks in advance,
Glen

.