TSqlModelOptions Class

Definition

Defines model wide options

public sealed class TSqlModelOptions
type TSqlModelOptions = class
Public NotInheritable Class TSqlModelOptions
Inheritance
TSqlModelOptions

Constructors

TSqlModelOptions()

Constructs the TSqlModelOptions

Properties

AllowSnapshotIsolation

Specifies the ALLOW_SNAPSHOT_ISOLATION database option.

AnsiNullDefaultOn

Specifies the ANSI_NULL_DEFAULT database option.

AnsiNullsOn

Specifies the ANSI_NULLS database option.

AnsiPaddingOn

Specifies the ANSI_PADDING database option.

AnsiWarningsOn

Specifies the ANSI_WARNINGS database option.

ArithAbortOn

Specifies the ARITH_ABORT database option.

AutoClose

Specifies the AUTO_CLOSE database option.

AutoCreateStatistics

Specifies the AUTO_CREATE_STATISTICS database option.

AutoCreateStatisticsIncremental

Specifies the AUTO_CREATE_STATISTICS INCREMENTAL database option.

AutoShrink

Specifies the AUTO_SHRINK database option.

AutoUpdateStatistics

Specifies the AUTO_UPDATE_STATISTICS database option.

AutoUpdateStatisticsAsync

Specifies the AUTO_UPDATE_STATISTICS_ASYNC database option.

CatalogCollation

Specifies the CATALOG_COLLATION_TYPE database option

ChangeTrackingAutoCleanup

Specifies the AUTO_CLEANUP database option.

ChangeTrackingEnabled

Specifies the CHANGE_TRACKING database option.

ChangeTrackingRetentionPeriod

Specifies the period of the CHANGE_RETENTION database option.

ChangeTrackingRetentionUnit

Specifies the unit of the CHANGE_RETENTION database option.

Collation

Specifies the Collation to use for the model. This is a string such as "SQL_Latin1_General_CP1_CI_AS", which must be a valid SQL Server Collation Name

CompatibilityLevel

Specifies the COMPATIBILITY_LEVEL database option.

ConcatNullYieldsNull

Specifies the CONCAT_NULL_YIELDS_NULL database option.

Containment

Specifies the CONTAINMENT database option.

CursorCloseOnCommit

Specifies the CURSOR_CLOSE_ON_COMMIT database option.

CursorDefaultGlobalScope

Specifies the CURSOR_DEFAULT database option.

DatabaseStateOffline

Specifies the ONLINE | OFFLINE database option.

DataRetentionEnabled

Specifies the Data Retention database option. Enabled only for Edge as of Now

DateCorrelationOptimizationOn

Specifies the DATE_CORRELATION_OPTIMIZATION database option.

DBChainingOn

Specifies the DB_CHAINING database option.

DbScopedConfigDWCompatibilityLevel

Specifies the Database Scoped Configuration DWCompatibilityLevel option.

DbScopedConfigLegacyCardinalityEstimation

Specifies the Database Scoped Configuration LEGACY_CARDINALITY_ESTIMATION option.

DbScopedConfigLegacyCardinalityEstimationSecondary

Specifies the Database Scoped Configuration LEGACY_CARDINALITY_ESTIMATION option for secondaries.

DbScopedConfigMaxDOP

Specifies the Database Scoped Configuration MAXDOP option.

DbScopedConfigMaxDOPSecondary

Specifies the Database Scoped Configuration MAXDOP option for secondaries.

DbScopedConfigParameterSniffing

Specifies the Database Scoped Configuration PARAMETER_SNIFFING option.

DbScopedConfigParameterSniffingSecondary

Specifies the Database Scoped Configuration PARAMETER_SNIFFING option for secondaries.

DbScopedConfigQueryOptimizerHotfixes

Specifies the Database Scoped Configuration QUERY_OPTIMIZER_HOTFIXES option.

DbScopedConfigQueryOptimizerHotfixesSecondary

Specifies the Database Scoped Configuration QUERY_OPTIMIZER_HOTFIXES option for secondaries.

DefaultFullTextLanguage

Specifies the DEFAULT_FULLTEXT_LANGUAGE database option.

DefaultLanguage

Specifies the DEFAULT_LANGUAGE database option.

DelayedDurabilityMode

Specifies the DELAYED_DURABILITY database option.

EngineVersion

Specifies what engine version should be targeted by the model. For On Premises platforms this value will be ignored as the engine version is fixed based on the platform. For the SqlAzure platform this value will be set and used to specify what T-SQL language features are supported.

FileStreamDirectoryName

Specifies the DIRECTORY_NAME database option.

FullTextEnabled

Specifies the sp_fulltext_database database option.

HonorBrokerPriority

Specifies the HONOR_BROKER_PRIORITY database option.

MemoryOptimizedElevateToSnapshot

Specifies the MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT database option.

NestedTriggersOn

Specifies the NESTED_TRIGGER database option.

NonTransactedFileStreamAccess

Specifies the NON_TRANSACTED_ACCESS database option.

NumericRoundAbortOn

Specifies the NUMERIC_ROUNDABORT database option.

PageVerifyMode

Specifies the PAGE_VERIFY database option.

ParameterizationOption

Specifies the PARAMETERIZATION database option.

QueryStoreCaptureMode

Specifies the query capture mode of QUERY_STORE database option.

QueryStoreDesiredState

Specifies the operation mode of QUERY_STORE database option.

QueryStoreFlushInterval

Specifies the Flush_Interval_Seconds setting of the QUERY_STORE database option.

QueryStoreIntervalLength

Specifies the Interval_Length_Minutes setting of the QUERY_STORE database option.

QueryStoreMaxPlansPerQuery

Specifies the Max_Plans_Per_Query setting of the QUERY_STORE database option.

QueryStoreMaxStorageSize

Specifies the Max_Storage_Size_MB setting of the QUERY_STORE database option.

QueryStoreStaleQueryThreshold

Specifies the Stale_Query_Threshold_Days setting of the QUERY_STORE database option.

QuotedIdentifierOn

Specifies the QUOTED_IDENTIFIER database option.

ReadOnly

Specifies the READ_ONLY | READ_WRITE database option.

RecoveryMode

Specifies the RECOVERY database option.

RecursiveTriggersOn

Specifies the RECURSIVE_TRIGGERS database option.

ServiceBrokerOption

Specifies the ENABLE_BROKER | DISABLE_BROKER | NEW_BROKER | ERROR_BROKER_CONVERSATIONS database option.

StorageType

Specifies the storage type - in memory or file backed. Default value is Memory

SupplementalLoggingOn

Specifies the SUPPLEMENTAL_LOGGING database option.

TargetRecoveryTimePeriod

Specifies the period of the TARGET_RECOVERY_TIME database option.

TargetRecoveryTimeUnit

Specifies the unit of the TARGET_RECOVERY_TIME database option.

TornPageProtectionOn

Specifies the TORN_PAGE_DETECTION database option.

TransactionIsolationReadCommittedSnapshot

Specifies the READ_COMMITTED_SNAPSHOT database option.

TransformNoiseWords

Specifies the TRANSFORM_NOISE_WORDS database option.

Trustworthy

Specifies the TRUSTWORTHY database option.

TwoDigitYearCutoff

Specifies the TWO_DIGIT_YEAR_CUTOFF database option.

UserAccessOption

Specifies the SINGLE_USER | RESTRICTED_USER | MULTI_USER database option.

VardecimalStorageFormatOn

Specifies the sp_db_vardecimal_storage_format database option.

WithEncryption

Specifies the ENCRYPTION database option.

Applies to