Information générale
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement