Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql Command Timeout
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
C# 1.1
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01043997
Message ID:
01245588
Vues:
31
The tips in the help file for globally changing the Command Timeout were very useful and easy to do because there is a CommandTimeout property on the dao class. Is there a way to globally change the isolation level of SQL Server too? The default isolation level for SQL Server is READ COMMITTED. I would like to globally change that level so that there is not so much SQL locking in my application.

Hint: SQL help says that there are two common ways to set the isolation level.
1. Run the SET TRANSACTION ISOLATION LEVEL Transact-SQL statement every time you open a connection.
2. ADO.NET applications using the System.Data.SqlClient managed namespace can specify an IsolationLevel option using the SqlConnection.BeginTransaction method.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform