SessionMode Property

Visual Basic
C#
C++/CLI

'Declaration
 
Public Property SessionMode As String

'Usage
 
Dim instance As TdConnectionStringBuilder
Dim value As String
 
instance.SessionMode = value
 
value = instance.SessionMode

public string SessionMode {get; set;}

public:
property String^ SessionMode {
   String^ get();
   void set (    String^ value);
}

Property Value

Valid values are Default, ANSI and TERADATA.

Session Mode	Description
Default	The Teradata Database system default will be used.
ANSI	In this mode, the Teradata Database implicitly starts a transaction. However the .NET Data Provider for Teradata immediately commits each Command to simulate Auto-Commit mode required by the ADO.NET specification. The Auto-Commit simulation might add an additional overhead of one (or more for batch-update) round-trip to the Teradata Database and back. TdConnection.BeginTransaction method must be used to explicitly control the transaction. String comparisons are case specific.
TERADATA	The Teradata Database commits (Auto-Commit) each commands; thus there is less overhead as compared to the ANSI session mode. String comparisons are case insensitive.

Refer to the Teradata Database manuals for additional information about the ANSI and Teradata session modes.

Default Value: DEFAULT

Target Platforms: Windows 7, Windows 8, Windows 8.1, Windows 10, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2

Reference

TdConnectionStringBuilder Class
TdConnectionStringBuilder Members