V
Vanaja Edara
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.
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.