TSqlModelOptions Class
Defines model wide options
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Dac.Model.TSqlModelOptions
Namespace: Microsoft.SqlServer.Dac.Model
Assembly: Microsoft.SqlServer.Dac.Extensions (in Microsoft.SqlServer.Dac.Extensions.dll)
Syntax
'Declaration
Public NotInheritable Class TSqlModelOptions
'Usage
Dim instance As TSqlModelOptions
public sealed class TSqlModelOptions
public ref class TSqlModelOptions sealed
[<SealedAttribute>]
type TSqlModelOptions = class end
public final class TSqlModelOptions
The TSqlModelOptions type exposes the following members.
Constructors
Name | Description | |
---|---|---|
![]() |
TSqlModelOptions | Constructs the TSqlModelOptions |
Top
Properties
Name | Description | |
---|---|---|
![]() |
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 |
![]() |
AutoShrink | Specifies the AUTO_SHRINK database option. |
![]() |
AutoUpdateStatistics | Specifies the AUTO_UPDATE_STATISTICS database option. |
![]() |
AutoUpdateStatisticsAsync | Specifies the AUTO_UPDATE_STATISTICS_ASYNC 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. |
![]() |
DateCorrelationOptimizationOn | Specifies the DATE_CORRELATION_OPTIMIZATION database option. |
![]() |
DBChainingOn | Specifies the DB_CHAINING database option. |
![]() |
DefaultFullTextLanguage | Specifies the DEFAULT_FULLTEXT_LANGUAGE database option. |
![]() |
DefaultLanguage | Specifies the DEFAULT_LANGUAGE database option. |
![]() |
FileStreamDirectoryName | Specifies the DIRECTORY_NAME database option. |
![]() |
FullTextEnabled | Specifies the sp_fulltext_database database option. |
![]() |
HonorBrokerPriority | Specifies the HONOR_BROKER_PRIORITY 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. |
![]() |
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. |
Top
Methods
Name | Description | |
---|---|---|
![]() |
Equals | (Inherited from Object.) |
![]() |
GetHashCode | (Inherited from Object.) |
![]() |
GetType | (Inherited from Object.) |
![]() |
ToString | (Inherited from Object.) |
Top
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.