ASP.NET connections with READ UNCOMMITTED

Question

I have a web application and all of its queries begin with

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Is there any way to create all connections with this isolation level? Can I implement this to connection pool in web.config or somewehere else?

http://stackoverflow.com/questions/3303782/can-i-set-the-isolation-level-in-the-connection-string and this http://stackoverflow.com/questions/2471055/why-use-a-read-uncommitted-isolation-level — adt, Jul 16 '12 at 09:33

score 2 · Answer 1 · answered Jul 16 '12 at 09:45

2

You cannot do.

you need to explicitly define the isolation level when you start a transaction.

answered Jul 16 '12 at 09:45

Vikash Sinha

193
8

Matthew Steeples · Accepted Answer · 2012-07-16T10:00:46.703

0

You can find this option in the properties of the database (if you are using SQL Server Management Studio) or alternatively using the ALTER DB statement.

ALTER DB dname
SET READ_COMMITTED_SNAPSHOT OFF

EDIT: Thanks to @Martin Smith, the command doesn't do what you want it to. See here for more details (differences between Read Committed with Snapshot off and Read Uncommitted).

edited Jul 16 '12 at 10:00

answered Jul 16 '12 at 09:16

Matthew Steeples

7,858
4
34
49

This doesn't do what the question asks for. – Martin Smith Jul 16 '12 at 09:42
This will change the default on the database server to what he's requesting (which is to create all connections with the specified isolation level) – Matthew Steeples Jul 16 '12 at 09:54
No it won't. It just changes how `READ_COMMITTED` is handled. – Martin Smith Jul 16 '12 at 09:54
My apologies, I misunderstood the statement and have found a page which explains it in better detail. I'll update my posting. – Matthew Steeples Jul 16 '12 at 09:56
I understand what you want to say. I can not change database's default isolation level so i should write this query to beginning of all of my queries. what a pity.. – ogun Jul 16 '12 at 11:11

ASP.NET connections with READ UNCOMMITTED

2 Answers2