'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;}
'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;}
Session Mode | Description |
---|---|
Default | The Advanced SQL Engine system default will be used. |
ANSI | In this mode, the Advanced SQL Engine 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 Advanced SQL Engine and back.
TdConnection.BeginTransaction method must be used to explicitly control the transaction. String comparisons are case specific. |
TERADATA | The SQL Engine 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 Advanced SQL Engine manuals for additional information about the ANSI and Teradata session modes.
Default Value: DEFAULT
Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019