The default transaction isolation level for SQL Server with ADO.NET

ado.netsql-server-2008transactions

What is the default transaction isolation level for SQL Server with ADO.NET? I am using a default installation of SQL Server and just the normal System.Data.SqlClient classes.

Best Answer

READ COMMITTED is the default isolation level for the Microsoft SQL Server Database Engine.

Source:

Here is how it compares to other isolation levels:

The MSDN documentation for SqlConnection.BeginTransaction() also states Read committed

... To reset the isolation level to the default (READ COMMITTED) ...

Related Topic