TSqlModelOptions Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Defines model wide options
public sealed class TSqlModelOptionstype TSqlModelOptions = classPublic 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. |