• Artigo

Propriedade do RDL TransactionDepth

Gets the current transaction depth for the referenced connection.

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (em Microsoft.SqlServer.ConnectionInfo.dll)

Sintaxe

'Declaração
Public ReadOnly Property TransactionDepth As Integer
    Get
'Uso
Dim instance As ServerConnection
Dim value As Integer

value = instance.TransactionDepth

public int TransactionDepth { get; }

public:
property int TransactionDepth {
    int get ();
}

member TransactionDepth : int

function get TransactionDepth () : int

Valor da propriedade

Tipo: System. . :: . .Int32
An Int32 value that specifies the current transaction depth for the referenced connection.

Comentários

A connection can experience nested transactions. The transaction depth refers to the number of nested transactions.

Exemplos

C#

ServerConnection conn = new ServerConnection();
Console.WriteLine(conn.TransactionDepth);

PowerShell

$conn = new-object Microsoft.SqlServer.Management.Common.ServerConnection
Write-Host $conn.TransactionDepth