Hi,

LLBLGen v5.7.0

was curious if docs need an update. When SqlServerCompatibilityLevel enum is decompiled:

/// <summary>
    /// Produce SQL which is compatible with SqlServer 2012 and up (default)
    /// </summary>
    SqlServer2012,

however https://www.llblgen.com/Documentation/5.7/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/FeaturesPerDB/Sqlserver.htm states:

By default the compatibility mode is set to SqlServerCompatibilityLevel.SqlServer2005

So which one?

Thank you!

Good catch. It's the 2005 one.

According to the following definition in the SQLServerDQE /DynamicQueryEngine.cd

private static SqlServerCompatibilityLevel _defaultCompatibilityLevel = SqlServerCompatibilityLevel.SqlServer2005;

Also in the generated DataAccessAdapter.cs it's mentioned that the default is 2005

private Nullable<SqlServerCompatibilityLevel> _compatibilityLevel = null;

/// <summary>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.</summary>
public Nullable<SqlServerCompatibilityLevel> CompatibilityLevel
{
    get { return _compatibilityLevel; }
    set { _compatibilityLevel = value; }
}

Alright, I'll remove the web/app.config appSettings value and use:

.SetDefaultCompatibilityLevel( SqlServerCompatibilityLevel.SqlServer2012 )

then.

Thank you!

As 2005 is out of support, it's a little weird we still have that as the default. We'll switch to 2012+ in the next version. (and will correct the comment)

Otis wrote:

As 2005 is out of support, it's a little weird we still have that as the default. We'll switch to 2012+ in the next version. (and will correct the comment)

Alright, I'll keep the explicit config for now at least. Thank you!