c# - How do I enable nested transactions with ADO.NET and SQL Server? -

I have the same question, instead of checking, how can I give permission for nested transactions?

I am using Microsoft SQL Server Database with ADO.net. I have seen examples using T-SQL and start using transactions using the transaction names and using them. After calling the connection. Restricted behavior, I call the second function in the same connection, and this call starts. Transaction again gives me an exception:

  SqlConnection does not support parallel transactions.  

It appears that many Microsoft versions allow this, but I can not understand how to do this with my .mdf file.

How do I use Nested Transactions with C # and ADO.NET in a Microsoft SQL Server database?

The entire SQL Server does not support nested transactions. In T-SQL, you can issue a BEGIN TRAN inside one first BEGIN TRAN but this feature is for this only external transaction that matters to SQL Server The .NET client for ( SqlConnection ) does not even allow you to do this, and when you try, it throws an exception.