How .net allows nested transactions with TransactionScopeOption

543 Views Asked by At

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

There are 1 best solutions below

0
On

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.