I have learned that Oracle & sql server database does not allow nested transactions. Then how does c# allow us to perform nested transactions using transactionscopeoption?
Asked
Active
Viewed 533 times
1
-
MS SQL Allows Nested Transactions, even distributed ones. Can you share your source? – DaveShaw Jul 06 '10 at 13:30
1 Answers
2
SQL Server does support nested transactions.
Had it not supported nested transactions, you would (presumably) have gotten an exception when using SQL Server in a nested transaction.
SLaks
- 868,454
- 176
- 1,908
- 1,964