DynamicQueryEngine Properties

The per-instance compatibility level used by this DQE instance. Default is the one set globally, which is by default SqlServer2005 (for 2005+). Compatibility level influences the query generated for paging, sequence name (@@IDENTITY/SCOPE_IDENTITY()), and usage of newsequenceid() in inserts. It also influences the ado.net provider to use. This way you can switch between SqlServer server client 'SqlClient' and SqlServer CE Desktop.

Gets / sets creator

The default compatibility level used by the DQE. Default is SqlServer2005 (for 2005+). To utilize SqlServer 2000 specific features, set this property to SqlServer2000, either through a setting in the .config file of your application or by setting this parameter once in your application. Compatibility level influences the query generated for paging, sequence name (@@IDENTITY/SCOPE_IDENTITY()), and usage of newsequenceid() in inserts. It also influences the ado.net provider to use. This way you can switch between SqlServer server client 'SqlClient' and SqlServer CE Desktop.

Gets or sets the distinct filtering preference to use. The default value is the value of the global variable DynamicQueryEngineBase.DistinctFilteringPreferenceDefault.

Gets the DbProviderFactory to use for this DQE.

Gets the function mappings for the particular DQE. These function mappings are static and therefore not changeable.

Gets / sets perCallCatalogNameOverwrites name pairs

Gets / sets perCallSchemaNameOverwrites name pairs

Gets whether the database of this DQE supports packed queries, which are queries with multiple SQL statements packed together in a single DbCommand. By default this property returns false.