Click or drag to resize

DynamicQueryEngineDefaultCompatibilityLevel Property

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.

Namespace:  SD.LLBLGen.Pro.DQE.SqlServer
Assembly:  SD.LLBLGen.Pro.DQE.SqlServer (in SD.LLBLGen.Pro.DQE.SqlServer.dll) Version: 5.7.0.0 (5.7.0)
Syntax
public static SqlServerCompatibilityLevel DefaultCompatibilityLevel { get; set; }

Property Value

Type: SqlServerCompatibilityLevel
Remarks
Setting this property will overrule a similar setting in the .config file. Don't set this property when queries are executed as it might switch factories for ADO.NET elements which could result in undefined behavior, as it's a global setting, inherited by all DQE instances on creation, so set this property at startup of your application; it affects all queries in your application using this DQE
See Also