Isolation level inheritance

Question

0.00/5 (No votes)

See more:

Hi, I have a transaction scope defined for my codes. But there is one thing I dont understand about the isolation level for transaction scope. If I have a line of code that is outside of the transaction scope, would the isolation level be inherited into the line of codes?
Below are my example:

C#

using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew, TransactionUtil.GetTransactionOptions(600)))
{
//do something here
//isolation level is ReadCommitted
}
//new line of codes here

Any help would be appreciated. Thank you.

What I have tried:

1. Researched online for article explanation.

Posted 27-Mar-16 22:13pm

Jamie888

Updated 28-Mar-16 3:48am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2016-03-28T03:48:00

This CodeProject article All About TransactionScope[^] goes into some detail about the TransactionScope class, which may help you.

You also need to be aware of an issue with the class for use with SQL Server - see this article using new TransactionScope() Considered Harmful | David Browne's Web Log[^]

My gut feel would be that the new lines of code would not inherit the isolation level, in the same way that if isolation level is set within a stored procedure in sql, the isolation level reverts back to whatever it was when the SP terminates. You can prove or disprove this by creating a new transaction (without setting isolation level) and querying the Transaction.IsolationLevel property.

If this is being used for a SQL Server connection then you can confirm or deny the behaviour by querying the Isolation Level currently on the connection (assuming you are using the same one) - This article has some C# code for doing that Getting and setting the Transaction Isolation Level on a SQL Entity Connection[^]

Try for the empirical evidence in whatever you are using TransactionScope for in your own code.

Personally I would never assume that the level is inherited and would explicitly set it myself.