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.4.0.0 (5.4.0)
Syntax public static SqlServerCompatibilityLevel DefaultCompatibilityLevel { get; set; }
Public Shared Property DefaultCompatibilityLevel As SqlServerCompatibilityLevel
Get
Set
Property Value
Type:
SqlServerCompatibilityLevelRemarks 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