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.

See Also

Reference

Microsoft.SqlServer.Dac.Model Namespace