UseEnhancedSchemaTable Property

Gets or sets a Boolean value that indicates whether TdDataReader.GetSchemaTable method should return additional metadata information (e.g. IsKey and IsUnique).

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Property UseEnhancedSchemaTable As Boolean

'Usage
 
Dim instance As TdConnectionStringBuilder
Dim value As Boolean
 
instance.UseEnhancedSchemaTable = value
 
value = instance.UseEnhancedSchemaTable

public bool UseEnhancedSchemaTable {get; set;}

public:
property bool UseEnhancedSchemaTable {
   bool get();
   void set (    bool value);
}

Property Value

The current value of UseEnhancedSchemaTable property, or the default value of true if none has been supplied.

Remarks

This property has been deprecated.

This property controls whether the Data Provider should retrieve additional result set metadata from the Advanced SQL Engine. This feature is available when connected to the Advanced SQL Engine 6.2 or higher.

TdDataAdapter class can use the metadata to set properties and constraints on the DataTable. For example IsKey and IsUnique metadata fields are used to set constraints on a DataTable.

The TdDataAdapter.SelectCommand must return a Key in order for TdCommandBuilder to generate UPDATE, INSERT and DELETE SQL commands now that UseEnhancedSchemaTable is always set to true.

UseEnhancedSchemaTable property must be set to false for backward compatibility with Data Provider version 12.0 or earlier. (The value no longer has any effect on TdCommandBuilder.)

Default Value: true

Requirements

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

Reference

TdConnectionStringBuilder Class
TdConnectionStringBuilder Members