SQL Passthrough DataSet Properties

The following properties are available for SQL Passthrough DataSet objects, grouped by the categories shown in the SQL Passthrough DataSet editor.

Information

Property Type Default Description

ID

string

The string value that uniquely identifies the metadata.

Name

string

The name of the metadata object.

Misc

Property Type Default Description

ConcurrentQueryExecutionEnabled

bool

false

Controls whether the SQLPassthroughDataSet queries are processed concurrently.

By default, the queries are processed sequentially (one after another), but in certain cases, application performance may be enhanced by running all queries in the SQLPassthroughDataSet concurrently (simultaneously)."

Queries

Query[]

An array of Query objects to execute.

SessionCachingEnabled

bool

false

Controls whether the data generated by the SQLPassthroughDataSet queries are added to the session cache.

By default, the data are not cached. Session caching should only be enabled when the results of the queries will not change over the course of a session (i.e. when the queries are not data-dependent.) When the results are not data-dependent, performance can be improved by enabling session caching.

This setting is only applicable when the application’s SessionCachingEnabled setting is true.

TestTokens

TokenTable

The token definitions assigned to the SQLPassthroughDataSet for testing. The test tokens are used only when testing the data set.