Isolation Level
From: Vanaja Edara (vanaja.edara_at_brinksinc.com)
Date: 02/19/04
- Next message: Aamir Ghanchi: "Re: form controls for relational tables with one-to-one correspondence"
- Previous message: TheGuru: "Re: There is already an open DataReader associated with this Connection which must be closed first, AGAIN !!!!!!"
- Next in thread: Miha Markic [MVP C#]: "Re: Isolation Level"
- Reply: Miha Markic [MVP C#]: "Re: Isolation Level"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 19 Feb 2004 09:42:17 -0600
Hi,
We have an Asp.Net applcation with Sql Server as back end. I have a
base class function that takes a SqlCommand Object as a parameter and
returns a datatable. I want to set the Isolation to "Read Uncommited" (Sql
Server's default Isolation Level is "Read Commited") as I am just selecting
some data from the tables. When I try to do the following :
objSqlCommand.Transaction.IsolationLevel = IsolationLevel.ReadUncommitted
The system says IsolationLevel is a Readonly property.
So the only option that I have currently is to set the Isolation Level to
"Read Uncommitted" in the Stored Procedures.
Is there a way to set it in the code so that I don't have to set it for each
stored procedure.
Thanks a lot.
- Next message: Aamir Ghanchi: "Re: form controls for relational tables with one-to-one correspondence"
- Previous message: TheGuru: "Re: There is already an open DataReader associated with this Connection which must be closed first, AGAIN !!!!!!"
- Next in thread: Miha Markic [MVP C#]: "Re: Isolation Level"
- Reply: Miha Markic [MVP C#]: "Re: Isolation Level"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
