multi scope in the same transacction, help!

Question

Hi, I have a database with 190 tables and 190 scopes, I mean, one scope per table (the business requires it), I would need that all scopes are in the same transaction and if some one scope fails, all the scopes to go rollback.

can someone help? thanks!!!

Answer 1

the transaction is at the scope level. any particular reason why you have to do one scope per table? have a look at some thoughts around scoping: Sync Framework Scope and SQL Azure Data Sync Dataset Considerations

also, what do you mean by "scope fails"?, most errors on synching (real SQL error and conflicts applying rows) are raised as conflicts or errors that you can handle in the ApplyChangeFailed event, and even that doesn't roll back the changes it already applied if some rows cannot be applied.

also, have a look at this discussion: Is the transaction based on scope level or table level?‎