Hi all,
Its been some time since I was here.
I just generated my first DAL in LLBL2.0. When I wanted to compile the code I got the following error
'CompatibilityLevel' is not a member of 'SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine'.
The line causing the error is in DataAccessAdapter.vb in the DBSpecific project
''' <summary>
''' Sets the compatibility level used by the DQE. Default Is SqlServer2000. To utilize SqlServer 2005 specific features, Set this parameter
''' To SqlServer2005, either through a setting In the .config file of your application Or by calling this method once In your application.
''' Compatibility level influences the query generated For paging, sequence name (@@IDENTITY/SCOPE_IDENTITY()), And usage of newsequenceid() In inserts.
''' </summary>
''' <parameter name="compatibilityLevel">the compatibility level the DQE should be running On. Default Is SqlServer 2000 And up.</parameter>
''' <remarks>Setting the compatibility level Is a global change. Calling this method will overrule a similar setting In the .config file.</remarks>
Public Shared Sub SetSqlServerCompatibilityLevel(compatibilityLevel As SqlServerCompatibilityLevel)
SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine.CompatibilityLevel = compatibilityLevel
End Sub