How does rolling back an application level transaction interact with SqlDataAdapter events in ADO.NE
Posted
by ilasno
on Stack Overflow
See other posts from Stack Overflow
or by ilasno
Published on 2010-05-04T01:09:12Z
Indexed on
2010/05/04
1:18 UTC
Read the original article
Hit count: 374
When utilizing the RowUpdated event in the SqlAdapter class, i'm assuming that it is raised directly following the return of the database interaction that executes the update.
If that update is part of an application level transaction (utilizing the SqlTransaction class) which is then rolled back, does this affect or interact at all with the RowUpdated event? Or is the RowUpdated event not raised until after the transaction is committed (this seems unlikely, but i couldn't find documentation)?
If RowUpdated has already been raised, and then the transaction is rolled back, any good ideas on how to adjust something that may have been done in RowUpdated that should then, also be rolled back?
© Stack Overflow or respective owner
