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.

public SqlServerCompatibilityLevel CompatibilityLevel { get; set; }

Public Property CompatibilityLevel As SqlServerCompatibilityLevel
	Get
	Set