以下方法应该在打开的连接上执行脏读取,没有事务。我在哪里设置 IsolationLevel?
public string DoDirtyRead(string storedProcName, SqlConnection connection)
{
using (SqlCommand command = new SqlCommand(storedProcName, connection))
{
command.CommandType = CommandType.StoredProcedure;
// HOW TO SET IsolationLevel to READ_UNCOMMITTED here?
command.ExecuteNonQuery();
}
}
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
。然后该连接将保持这种状态,直到它被关闭或以其他方式被修改。 - DarrenMB