TSqlModelOptions TSqlModelOptions TSqlModelOptions Class

Definition

Defines model wide options

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

Constructors

TSqlModelOptions() TSqlModelOptions() TSqlModelOptions()

Constructs the TSqlModelOptions

Properties

AllowSnapshotIsolation AllowSnapshotIsolation AllowSnapshotIsolation

Specifies the ALLOW_SNAPSHOT_ISOLATION database option.

AnsiNullDefaultOn AnsiNullDefaultOn AnsiNullDefaultOn

Specifies the ANSI_NULL_DEFAULT database option.

AnsiNullsOn AnsiNullsOn AnsiNullsOn

Specifies the ANSI_NULLS database option.

AnsiPaddingOn AnsiPaddingOn AnsiPaddingOn

Specifies the ANSI_PADDING database option.

AnsiWarningsOn AnsiWarningsOn AnsiWarningsOn

Specifies the ANSI_WARNINGS database option.

ArithAbortOn ArithAbortOn ArithAbortOn

Specifies the ARITH_ABORT database option.

AutoClose AutoClose AutoClose

Specifies the AUTO_CLOSE database option.

AutoCreateStatistics AutoCreateStatistics AutoCreateStatistics

Specifies the AUTO_CREATE_STATISTICS database option.

AutoCreateStatisticsIncremental AutoCreateStatisticsIncremental AutoCreateStatisticsIncremental

Specifies the AUTO_CREATE_STATISTICS INCREMENTAL database option.

AutoShrink AutoShrink AutoShrink

Specifies the AUTO_SHRINK database option.

AutoUpdateStatistics AutoUpdateStatistics AutoUpdateStatistics

Specifies the AUTO_UPDATE_STATISTICS database option.

AutoUpdateStatisticsAsync AutoUpdateStatisticsAsync AutoUpdateStatisticsAsync

Specifies the AUTO_UPDATE_STATISTICS_ASYNC database option.

CatalogCollation CatalogCollation CatalogCollation

Specifies the CATALOG_COLLATION_TYPE database option

ChangeTrackingAutoCleanup ChangeTrackingAutoCleanup ChangeTrackingAutoCleanup

Specifies the AUTO_CLEANUP database option.

ChangeTrackingEnabled ChangeTrackingEnabled ChangeTrackingEnabled

Specifies the CHANGE_TRACKING database option.

ChangeTrackingRetentionPeriod ChangeTrackingRetentionPeriod ChangeTrackingRetentionPeriod

Specifies the period of the CHANGE_RETENTION database option.

ChangeTrackingRetentionUnit ChangeTrackingRetentionUnit ChangeTrackingRetentionUnit

Specifies the unit of the CHANGE_RETENTION database option.

Collation Collation 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 CompatibilityLevel CompatibilityLevel

Specifies the COMPATIBILITY_LEVEL database option.

ConcatNullYieldsNull ConcatNullYieldsNull ConcatNullYieldsNull

Specifies the CONCAT_NULL_YIELDS_NULL database option.

Containment Containment Containment

Specifies the CONTAINMENT database option.

CursorCloseOnCommit CursorCloseOnCommit CursorCloseOnCommit

Specifies the CURSOR_CLOSE_ON_COMMIT database option.

CursorDefaultGlobalScope CursorDefaultGlobalScope CursorDefaultGlobalScope

Specifies the CURSOR_DEFAULT database option.

DatabaseStateOffline DatabaseStateOffline DatabaseStateOffline

Specifies the ONLINE | OFFLINE database option.

DateCorrelationOptimizationOn DateCorrelationOptimizationOn DateCorrelationOptimizationOn

Specifies the DATE_CORRELATION_OPTIMIZATION database option.

DBChainingOn DBChainingOn DBChainingOn

Specifies the DB_CHAINING database option.

DbScopedConfigLegacyCardinalityEstimation DbScopedConfigLegacyCardinalityEstimation DbScopedConfigLegacyCardinalityEstimation

Specifies the Database Scoped Configuration LEGACY_CARDINALITY_ESTIMATION option.

DbScopedConfigLegacyCardinalityEstimationSecondary DbScopedConfigLegacyCardinalityEstimationSecondary DbScopedConfigLegacyCardinalityEstimationSecondary

Specifies the Database Scoped Configuration LEGACY_CARDINALITY_ESTIMATION option for secondaries.

DbScopedConfigMaxDOP DbScopedConfigMaxDOP DbScopedConfigMaxDOP

Specifies the Database Scoped Configuration MAXDOP option.

DbScopedConfigMaxDOPSecondary DbScopedConfigMaxDOPSecondary DbScopedConfigMaxDOPSecondary

Specifies the Database Scoped Configuration MAXDOP option for secondaries.

DbScopedConfigParameterSniffing DbScopedConfigParameterSniffing DbScopedConfigParameterSniffing

Specifies the Database Scoped Configuration PARAMETER_SNIFFING option.

DbScopedConfigParameterSniffingSecondary DbScopedConfigParameterSniffingSecondary DbScopedConfigParameterSniffingSecondary

Specifies the Database Scoped Configuration PARAMETER_SNIFFING option for secondaries.

DbScopedConfigQueryOptimizerHotfixes DbScopedConfigQueryOptimizerHotfixes DbScopedConfigQueryOptimizerHotfixes

Specifies the Database Scoped Configuration QUERY_OPTIMIZER_HOTFIXES option.

DbScopedConfigQueryOptimizerHotfixesSecondary DbScopedConfigQueryOptimizerHotfixesSecondary DbScopedConfigQueryOptimizerHotfixesSecondary

Specifies the Database Scoped Configuration QUERY_OPTIMIZER_HOTFIXES option for secondaries.

DefaultFullTextLanguage DefaultFullTextLanguage DefaultFullTextLanguage

Specifies the DEFAULT_FULLTEXT_LANGUAGE database option.

DefaultLanguage DefaultLanguage DefaultLanguage

Specifies the DEFAULT_LANGUAGE database option.

DelayedDurabilityMode DelayedDurabilityMode DelayedDurabilityMode

Specifies the DELAYED_DURABILITY database option.

EngineVersion EngineVersion 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 FileStreamDirectoryName FileStreamDirectoryName

Specifies the DIRECTORY_NAME database option.

FullTextEnabled FullTextEnabled FullTextEnabled

Specifies the sp_fulltext_database database option.

HonorBrokerPriority HonorBrokerPriority HonorBrokerPriority

Specifies the HONOR_BROKER_PRIORITY database option.

MemoryOptimizedElevateToSnapshot MemoryOptimizedElevateToSnapshot MemoryOptimizedElevateToSnapshot

Specifies the MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT database option.

NestedTriggersOn NestedTriggersOn NestedTriggersOn

Specifies the NESTED_TRIGGER database option.

NonTransactedFileStreamAccess NonTransactedFileStreamAccess NonTransactedFileStreamAccess

Specifies the NON_TRANSACTED_ACCESS database option.

NumericRoundAbortOn NumericRoundAbortOn NumericRoundAbortOn

Specifies the NUMERIC_ROUNDABORT database option.

PageVerifyMode PageVerifyMode PageVerifyMode

Specifies the PAGE_VERIFY database option.

ParameterizationOption ParameterizationOption ParameterizationOption

Specifies the PARAMETERIZATION database option.

QueryStoreCaptureMode QueryStoreCaptureMode QueryStoreCaptureMode

Specifies the query capture mode of QUERY_STORE database option.

QueryStoreDesiredState QueryStoreDesiredState QueryStoreDesiredState

Specifies the operation mode of QUERY_STORE database option.

QueryStoreFlushInterval QueryStoreFlushInterval QueryStoreFlushInterval

Specifies the Flush_Interval_Seconds setting of the QUERY_STORE database option.

QueryStoreIntervalLength QueryStoreIntervalLength QueryStoreIntervalLength

Specifies the Interval_Length_Minutes setting of the QUERY_STORE database option.

QueryStoreMaxPlansPerQuery QueryStoreMaxPlansPerQuery QueryStoreMaxPlansPerQuery

Specifies the Max_Plans_Per_Query setting of the QUERY_STORE database option.

QueryStoreMaxStorageSize QueryStoreMaxStorageSize QueryStoreMaxStorageSize

Specifies the Max_Storage_Size_MB setting of the QUERY_STORE database option.

QueryStoreStaleQueryThreshold QueryStoreStaleQueryThreshold QueryStoreStaleQueryThreshold

Specifies the Stale_Query_Threshold_Days setting of the QUERY_STORE database option.

QuotedIdentifierOn QuotedIdentifierOn QuotedIdentifierOn

Specifies the QUOTED_IDENTIFIER database option.

ReadOnly ReadOnly ReadOnly

Specifies the READ_ONLY | READ_WRITE database option.

RecoveryMode RecoveryMode RecoveryMode

Specifies the RECOVERY database option.

RecursiveTriggersOn RecursiveTriggersOn RecursiveTriggersOn

Specifies the RECURSIVE_TRIGGERS database option.

ServiceBrokerOption ServiceBrokerOption ServiceBrokerOption

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

StorageType StorageType StorageType

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

SupplementalLoggingOn SupplementalLoggingOn SupplementalLoggingOn

Specifies the SUPPLEMENTAL_LOGGING database option.

TargetRecoveryTimePeriod TargetRecoveryTimePeriod TargetRecoveryTimePeriod

Specifies the period of the TARGET_RECOVERY_TIME database option.

TargetRecoveryTimeUnit TargetRecoveryTimeUnit TargetRecoveryTimeUnit

Specifies the unit of the TARGET_RECOVERY_TIME database option.

TornPageProtectionOn TornPageProtectionOn TornPageProtectionOn

Specifies the TORN_PAGE_DETECTION database option.

TransactionIsolationReadCommittedSnapshot TransactionIsolationReadCommittedSnapshot TransactionIsolationReadCommittedSnapshot

Specifies the READ_COMMITTED_SNAPSHOT database option.

TransformNoiseWords TransformNoiseWords TransformNoiseWords

Specifies the TRANSFORM_NOISE_WORDS database option.

Trustworthy Trustworthy Trustworthy

Specifies the TRUSTWORTHY database option.

TwoDigitYearCutoff TwoDigitYearCutoff TwoDigitYearCutoff

Specifies the TWO_DIGIT_YEAR_CUTOFF database option.

UserAccessOption UserAccessOption UserAccessOption

Specifies the SINGLE_USER | RESTRICTED_USER | MULTI_USER database option.

VardecimalStorageFormatOn VardecimalStorageFormatOn VardecimalStorageFormatOn

Specifies the sp_db_vardecimal_storage_format database option.

WithEncryption WithEncryption WithEncryption

Specifies the ENCRYPTION database option.

Applies to