Enum SqlServerEngineEdition

Namespace

NextORM.SqlServer

Assembly

nextorm.sqlserver.dll

The SQL Server engine edition a SqlServerDataContext declares, mirroring the values of SERVERPROPERTY('EngineEdition'). The declaration is immutable and supplied by the caller: nextorm never queries the server for this value, so the emitted SQL stays a pure function of the constructor arguments.

Only SqlDatabase (5), AzureSqlManagedInstance (8) and MicrosoftFabricSqlDatabase (12) grant the edition-derived native json capability, because those are the products whose engine has the native json data type while reporting a ProductMajorVersion below 17. AzureSynapseServerlessSqlPoolOrMicrosoftFabric (11) does not grant it: the value covers "Azure Synapse serverless SQL pool, or Microsoft Fabric", and the serverless pool has no json column type. Every other value, and an unset edition, grant nothing; the unchanged version gate (major 17 or higher) still applies on its own.

public enum SqlServerEngineEdition

Extension Methods

EntityBuilderExtensions.AsEntityBuilder<T>(object?)

Fields

AzureSqlEdge = 9

Azure SQL Edge; grants no edition-derived capability.

AzureSqlManagedInstance = 8

Azure SQL Managed Instance; grants the edition-derived native json capability.

AzureSynapseAnalytics = 6

Azure Synapse Analytics; grants no edition-derived capability.

AzureSynapseServerlessSqlPoolOrMicrosoftFabric = 11

Azure Synapse serverless SQL pool, or Microsoft Fabric. Deliberately grants no edition-derived capability: the serverless pool has no native json column type.

Enterprise = 3

Enterprise edition, including Enterprise Developer, Developer and Evaluation.

Express = 4

Express edition, including Express with Tools and Express with Advanced Services.

MicrosoftFabricSqlDatabase = 12

Microsoft Fabric SQL database; grants the edition-derived native json capability.

PersonalOrDesktop = 1

Personal or Desktop Engine (not available in SQL Server 2005 (9.x) and later).

SqlDatabase = 5

Azure SQL Database; grants the edition-derived native json capability.

Standard = 2

Standard edition, including Standard Developer, Web and Business Intelligence.