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?
+1
A:
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
2010-07-06 13:31:25