Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
TSqlModelOptions Class
Collapse the table of content
Expand the table of content

TSqlModelOptions Class

 

Defines model wide options

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

System.Object
  Microsoft.SqlServer.Dac.Model.TSqlModelOptions

public sealed class TSqlModelOptions

NameDescription
System_CAPS_pubmethodTSqlModelOptions()

Constructs the TSqlModelOptions

NameDescription
System_CAPS_pubpropertyAllowSnapshotIsolation

Specifies the ALLOW_SNAPSHOT_ISOLATION database option.

System_CAPS_pubpropertyAnsiNullDefaultOn

Specifies the ANSI_NULL_DEFAULT database option.

System_CAPS_pubpropertyAnsiNullsOn

Specifies the ANSI_NULLS database option.

System_CAPS_pubpropertyAnsiPaddingOn

Specifies the ANSI_PADDING database option.

System_CAPS_pubpropertyAnsiWarningsOn

Specifies the ANSI_WARNINGS database option.

System_CAPS_pubpropertyArithAbortOn

Specifies the ARITH_ABORT database option.

System_CAPS_pubpropertyAutoClose

Specifies the AUTO_CLOSE database option.

System_CAPS_pubpropertyAutoCreateStatistics

Specifies the AUTO_CREATE_STATISTICS database option.

System_CAPS_pubpropertyAutoCreateStatisticsIncremental

Specifies the AUTO_CREATE_STATISTICS INCREMENTAL database option.

System_CAPS_pubpropertyAutoShrink

Specifies the AUTO_SHRINK database option.

System_CAPS_pubpropertyAutoUpdateStatistics

Specifies the AUTO_UPDATE_STATISTICS database option.

System_CAPS_pubpropertyAutoUpdateStatisticsAsync

Specifies the AUTO_UPDATE_STATISTICS_ASYNC database option.

System_CAPS_pubpropertyChangeTrackingAutoCleanup

Specifies the AUTO_CLEANUP database option.

System_CAPS_pubpropertyChangeTrackingEnabled

Specifies the CHANGE_TRACKING database option.

System_CAPS_pubpropertyChangeTrackingRetentionPeriod

Specifies the period of the CHANGE_RETENTION database option.

System_CAPS_pubpropertyChangeTrackingRetentionUnit

Specifies the unit of the CHANGE_RETENTION database option.

System_CAPS_pubpropertyCollation

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

System_CAPS_pubpropertyCompatibilityLevel

Specifies the COMPATIBILITY_LEVEL database option.

System_CAPS_pubpropertyConcatNullYieldsNull

Specifies the CONCAT_NULL_YIELDS_NULL database option.

System_CAPS_pubpropertyContainment

Specifies the CONTAINMENT database option.

System_CAPS_pubpropertyCursorCloseOnCommit

Specifies the CURSOR_CLOSE_ON_COMMIT database option.

System_CAPS_pubpropertyCursorDefaultGlobalScope

Specifies the CURSOR_DEFAULT database option.

System_CAPS_pubpropertyDatabaseStateOffline

Specifies the ONLINE | OFFLINE database option.

System_CAPS_pubpropertyDateCorrelationOptimizationOn

Specifies the DATE_CORRELATION_OPTIMIZATION database option.

System_CAPS_pubpropertyDBChainingOn

Specifies the DB_CHAINING database option.

System_CAPS_pubpropertyDefaultFullTextLanguage

Specifies the DEFAULT_FULLTEXT_LANGUAGE database option.

System_CAPS_pubpropertyDefaultLanguage

Specifies the DEFAULT_LANGUAGE database option.

System_CAPS_pubpropertyDelayedDurabilityMode

Specifies the DELAYED_DURABILITY database option.

System_CAPS_pubpropertyEngineVersion

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.

System_CAPS_pubpropertyFileStreamDirectoryName

Specifies the DIRECTORY_NAME database option.

System_CAPS_pubpropertyFullTextEnabled

Specifies the sp_fulltext_database database option.

System_CAPS_pubpropertyHonorBrokerPriority

Specifies the HONOR_BROKER_PRIORITY database option.

System_CAPS_pubpropertyMemoryOptimizedElevateToSnapshot

Specifies the MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT database option.

System_CAPS_pubpropertyNestedTriggersOn

Specifies the NESTED_TRIGGER database option.

System_CAPS_pubpropertyNonTransactedFileStreamAccess

Specifies the NON_TRANSACTED_ACCESS database option.

System_CAPS_pubpropertyNumericRoundAbortOn

Specifies the NUMERIC_ROUNDABORT database option.

System_CAPS_pubpropertyPageVerifyMode

Specifies the PAGE_VERIFY database option.

System_CAPS_pubpropertyParameterizationOption

Specifies the PARAMETERIZATION database option.

System_CAPS_pubpropertyQuotedIdentifierOn

Specifies the QUOTED_IDENTIFIER database option.

System_CAPS_pubpropertyReadOnly

Specifies the READ_ONLY | READ_WRITE database option.

System_CAPS_pubpropertyRecoveryMode

Specifies the RECOVERY database option.

System_CAPS_pubpropertyRecursiveTriggersOn

Specifies the RECURSIVE_TRIGGERS database option.

System_CAPS_pubpropertyServiceBrokerOption

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

System_CAPS_pubpropertyStorageType

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

System_CAPS_pubpropertySupplementalLoggingOn

Specifies the SUPPLEMENTAL_LOGGING database option.

System_CAPS_pubpropertyTargetRecoveryTimePeriod

Specifies the period of the TARGET_RECOVERY_TIME database option.

System_CAPS_pubpropertyTargetRecoveryTimeUnit

Specifies the unit of the TARGET_RECOVERY_TIME database option.

System_CAPS_pubpropertyTornPageProtectionOn

Specifies the TORN_PAGE_DETECTION database option.

System_CAPS_pubpropertyTransactionIsolationReadCommittedSnapshot

Specifies the READ_COMMITTED_SNAPSHOT database option.

System_CAPS_pubpropertyTransformNoiseWords

Specifies the TRANSFORM_NOISE_WORDS database option.

System_CAPS_pubpropertyTrustworthy

Specifies the TRUSTWORTHY database option.

System_CAPS_pubpropertyTwoDigitYearCutoff

Specifies the TWO_DIGIT_YEAR_CUTOFF database option.

System_CAPS_pubpropertyUserAccessOption

Specifies the SINGLE_USER | RESTRICTED_USER | MULTI_USER database option.

System_CAPS_pubpropertyVardecimalStorageFormatOn

Specifies the sp_db_vardecimal_storage_format database option.

System_CAPS_pubpropertyWithEncryption

Specifies the ENCRYPTION database option.

NameDescription
System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodToString()

(Inherited from Object.)

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

Return to top

Community Additions

ADD
Show:
© 2015 Microsoft