BeginTransaction(IsolationLevel) Method

Visual Basic
C#
C++/CLI

'Declaration
 
Public Overloads Shadows Function BeginTransaction( _
   ByVal isolationLevel As IsolationLevel _
) As TdTransaction

'Usage
 
Dim instance As TdConnection
Dim isolationLevel As IsolationLevel
Dim value As TdTransaction
 
value = instance.BeginTransaction(isolationLevel)

public new TdTransaction BeginTransaction( 
   IsolationLevel isolationLevel
)

public:
new TdTransaction^ BeginTransaction( 
   IsolationLevel isolationLevel
)

Parameters

isolationLevel: Isolation Level

Return Value

BeginTransaction returns an instance of the TdTransaction class which can be used to explicitly commit or rollback a transaction.

Exception	Description
System.ArgumentOutOfRangeException	Teradata does not directly support IsolationLevels. Therefore, the only acceptable value is System.Data.IsolationLevel.Serializable.
System.InvalidOperationException	There is an open transaction and Teradata does not support parallel transactions or TdConnection is in the Closed state.

By default a TdConnection operates in auto-commit mode. This simply means that all SQL commands are immediately committed irrespective of the Session Mode (See Teradata SQL manuals).

To wrap two or more SQL statements in one transaction, call BeginTransaction to start an explicit transaction. Use the TdTransaction object to Commit or Rollback the transaction.

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

Reference

TdConnection Class
TdConnection Members
Overload List