Freigeben über


TransactionDepth-Eigenschaft

Gets the current transaction depth for the referenced connection.

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

Syntax

'Declaration
Public ReadOnly Property TransactionDepth As Integer
    Get
'Usage
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

Eigenschaftswert

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

Hinweise

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

Beispiele

C#

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

PowerShell

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