Export (0) Print
Expand All

TSqlModelOptions Class

Defines model wide options

Object
  Microsoft.SqlServer.Dac.Model.TSqlModelOptions

Namespace:  Microsoft.SqlServer.Dac.Model
Assembly:  Microsoft.SqlServer.Dac.Extensions (in Microsoft.SqlServer.Dac.Extensions.dll)

public sealed class TSqlModelOptions

The TSqlModelOptions type exposes the following members.

  NameDescription
Public methodTSqlModelOptionsConstructs the TSqlModelOptions
Top

  NameDescription
Public propertyAllowSnapshotIsolationSpecifies the ALLOW_SNAPSHOT_ISOLATION database option.
Public propertyAnsiNullDefaultOnSpecifies the ANSI_NULL_DEFAULT database option.
Public propertyAnsiNullsOnSpecifies the ANSI_NULLS database option.
Public propertyAnsiPaddingOnSpecifies the ANSI_PADDING database option.
Public propertyAnsiWarningsOnSpecifies the ANSI_WARNINGS database option.
Public propertyArithAbortOnSpecifies the ARITH_ABORT database option.
Public propertyAutoCloseSpecifies the AUTO_CLOSE database option.
Public propertyAutoCreateStatisticsSpecifies the AUTO_CREATE_STATISTICS database option.
Public propertyAutoCreateStatisticsIncrementalSpecifies the AUTO_CREATE_STATISTICS INCREMENTAL database option.
Public propertyAutoShrinkSpecifies the AUTO_SHRINK database option.
Public propertyAutoUpdateStatisticsSpecifies the AUTO_UPDATE_STATISTICS database option.
Public propertyAutoUpdateStatisticsAsyncSpecifies the AUTO_UPDATE_STATISTICS_ASYNC database option.
Public propertyChangeTrackingAutoCleanupSpecifies the AUTO_CLEANUP database option.
Public propertyChangeTrackingEnabledSpecifies the CHANGE_TRACKING database option.
Public propertyChangeTrackingRetentionPeriodSpecifies the period of the CHANGE_RETENTION database option.
Public propertyChangeTrackingRetentionUnitSpecifies the unit of the CHANGE_RETENTION database option.
Public propertyCollationSpecifies 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
Public propertyCompatibilityLevelSpecifies the COMPATIBILITY_LEVEL database option.
Public propertyConcatNullYieldsNullSpecifies the CONCAT_NULL_YIELDS_NULL database option.
Public propertyContainmentSpecifies the CONTAINMENT database option.
Public propertyCursorCloseOnCommitSpecifies the CURSOR_CLOSE_ON_COMMIT database option.
Public propertyCursorDefaultGlobalScopeSpecifies the CURSOR_DEFAULT database option.
Public propertyDatabaseStateOfflineSpecifies the ONLINE | OFFLINE database option.
Public propertyDateCorrelationOptimizationOnSpecifies the DATE_CORRELATION_OPTIMIZATION database option.
Public propertyDBChainingOnSpecifies the DB_CHAINING database option.
Public propertyDefaultFullTextLanguageSpecifies the DEFAULT_FULLTEXT_LANGUAGE database option.
Public propertyDefaultLanguageSpecifies the DEFAULT_LANGUAGE database option.
Public propertyDelayedDurabilityModeSpecifies the DELAYED_DURABILITY database option.
Public propertyFileStreamDirectoryNameSpecifies the DIRECTORY_NAME database option.
Public propertyFullTextEnabledSpecifies the sp_fulltext_database database option.
Public propertyHonorBrokerPrioritySpecifies the HONOR_BROKER_PRIORITY database option.
Public propertyMemoryOptimizedElevateToSnapshotSpecifies the MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT database option.
Public propertyNestedTriggersOnSpecifies the NESTED_TRIGGER database option.
Public propertyNonTransactedFileStreamAccessSpecifies the NON_TRANSACTED_ACCESS database option.
Public propertyNumericRoundAbortOnSpecifies the NUMERIC_ROUNDABORT database option.
Public propertyPageVerifyModeSpecifies the PAGE_VERIFY database option.
Public propertyParameterizationOptionSpecifies the PARAMETERIZATION database option.
Public propertyQuotedIdentifierOnSpecifies the QUOTED_IDENTIFIER database option.
Public propertyReadOnlySpecifies the READ_ONLY | READ_WRITE database option.
Public propertyRecoveryModeSpecifies the RECOVERY database option.
Public propertyRecursiveTriggersOnSpecifies the RECURSIVE_TRIGGERS database option.
Public propertyServiceBrokerOptionSpecifies the ENABLE_BROKER | DISABLE_BROKER | NEW_BROKER | ERROR_BROKER_CONVERSATIONS database option.
Public propertyStorageTypeSpecifies the storage type - in memory or file backed. Default value is Memory
Public propertySupplementalLoggingOnSpecifies the SUPPLEMENTAL_LOGGING database option.
Public propertyTargetRecoveryTimePeriodSpecifies the period of the TARGET_RECOVERY_TIME database option.
Public propertyTargetRecoveryTimeUnitSpecifies the unit of the TARGET_RECOVERY_TIME database option.
Public propertyTornPageProtectionOnSpecifies the TORN_PAGE_DETECTION database option.
Public propertyTransactionIsolationReadCommittedSnapshotSpecifies the READ_COMMITTED_SNAPSHOT database option.
Public propertyTransformNoiseWordsSpecifies the TRANSFORM_NOISE_WORDS database option.
Public propertyTrustworthySpecifies the TRUSTWORTHY database option.
Public propertyTwoDigitYearCutoffSpecifies the TWO_DIGIT_YEAR_CUTOFF database option.
Public propertyUserAccessOptionSpecifies the SINGLE_USER | RESTRICTED_USER | MULTI_USER database option.
Public propertyVardecimalStorageFormatOnSpecifies the sp_db_vardecimal_storage_format database option.
Public propertyWithEncryptionSpecifies the ENCRYPTION database option.
Top

  NameDescription
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodToString (Inherited from Object.)
Top

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft