Microsoft.SqlServer.Dac.Model Namespace

Classes

Aggregate

Model schema container class for Aggregate

ApplicationRole

Model schema container class for ApplicationRole

Assembly

Model schema container class for Assembly

AssemblySource

Model schema container class for AssemblySource

AsymmetricKey

Model schema container class for AsymmetricKey

AuditAction

Model schema container class for AuditAction

AuditActionGroup

Model schema container class for AuditActionGroup

AuditActionSpecification

Model schema container class for AuditActionSpecification

BrokerPriority

Model schema container class for BrokerPriority

BuiltInServerRole

Model schema container class for BuiltInServerRole

Certificate

Model schema container class for Certificate

CheckConstraint

Model schema container class for CheckConstraint

ClrTableOption

Model schema container class for ClrTableOption

ClrTableOption.OrderColumnsRelationship

Model schema container class for OrderColumnsRelationship

ClrTypeMethod

Model schema container class for ClrTypeMethod

ClrTypeMethodParameter

Model schema container class for ClrTypeMethodParameter

ClrTypeProperty

Model schema container class for ClrTypeProperty

Column

Model schema container class for Column

ColumnStoreIndex

Model schema container class for ColumnStoreIndex

ColumnStoreIndex.ColumnsRelationship

Model schema container class for ColumnsRelationship

Contract

Model schema container class for Contract

Contract.MessagesRelationship

Model schema container class for MessagesRelationship

Credential

Model schema container class for Credential

CryptographicProvider

Model schema container class for CryptographicProvider

DacModelError

Represents a model blocking error.

DacModelException

Exception throw from DAC model errors.

DacModelMessage

Represents an error or a warning raised during model validation.

DatabaseAuditSpecification

Model schema container class for DatabaseAuditSpecification

DatabaseCredential

Model schema container class for DatabaseCredential

DatabaseDdlTrigger

Model schema container class for DatabaseDdlTrigger

DatabaseEncryptionKey

Model schema container class for DatabaseEncryptionKey

DatabaseEventNotification

Model schema container class for DatabaseEventNotification

DatabaseEventSession

Model schema container class for DatabaseEventSession

DatabaseMirroringLanguageSpecifier

Model schema container class for DatabaseMirroringLanguageSpecifier

DatabaseOptions

Model schema container class for DatabaseOptions

DataCompressionOption

Model schema container class for DataCompressionOption

DataType

Model schema container class for DataType

Default

Model schema container class for Default

DefaultConstraint

Model schema container class for DefaultConstraint

DisplayServices

Provides a set of services for providing user-visible values for objects in the public model API.

DmlTrigger

Model schema container class for DmlTrigger

Endpoint

Model schema container class for Endpoint

ErrorMessage

Model schema container class for ErrorMessage

EventGroup

Model schema container class for EventGroup

EventSession

Model schema container class for EventSession

EventSessionAction

Model schema container class for EventSessionAction

EventSessionDefinitions

Model schema container class for EventSessionDefinitions

EventSessionSetting

Model schema container class for EventSessionSetting

EventSessionTarget

Model schema container class for EventSessionTarget

EventTypeSpecifier

Model schema container class for EventTypeSpecifier

ExtendedProcedure

Model schema container class for ExtendedProcedure

ExtendedProperty

Model schema container class for ExtendedProperty

ExternalDataSource

Model schema container class for ExternalDataSource

ExternalFileFormat

Model schema container class for ExternalFileFormat

ExternalTable

Model schema container class for ExternalTable

Filegroup

Model schema container class for Filegroup

FileTable

Model schema container class for FileTable

ForeignKeyConstraint

Model schema container class for ForeignKeyConstraint

FullTextCatalog

Model schema container class for FullTextCatalog

FullTextIndex

Model schema container class for FullTextIndex

FullTextIndexColumnSpecifier

Model schema container class for FullTextIndexColumnSpecifier

FullTextStopList

Model schema container class for FullTextStopList

HttpProtocolSpecifier

Model schema container class for HttpProtocolSpecifier

Index

Model schema container class for Index

Index.ColumnsRelationship

Model schema container class for ColumnsRelationship

LinkedServer

Model schema container class for LinkedServer

LinkedServerLogin

Model schema container class for LinkedServerLogin

Login

Model schema container class for Login

MasterKey

Model schema container class for MasterKey

MessageType

Model schema container class for MessageType

ModelCollationComparer

Comparer that can compare strings and ObjectIdentifiers using the collation of a TSqlModel. This can be very useful when comparing objects in the model since comparisons will be consistent with the expected comparison results in SQL Server

ModelExtractOptions

Defines options that affect the behavior of loading a model from a database.

ModelLoadOptions

Options for loading a model from a data source such as a Dacpac file.

These options can be very important depending on the scenario. For instance when running static code analysis using the CodeAnalysisService it is strongly recommended that the LoadAsScriptBackedModel option be set to true, as many rules expect a fully scripted source and may not operate as expected on a non script-backed model.

ModelMetadataClass

The metadata class for metadata properties.

ModelPropertyClass

The metadata class for properties.

ModelRelationshipClass

The metadata class for relationships.

ModelRelationshipInstance

Represents a reference from one TSqlObject to another, which might be unresolved.

ModelSchema

Model schema for TSqlModel

ModelTypeClass

The metadata class for TSqlObjects.

ObjectIdentifier
Parameter

Model schema container class for Parameter

PartitionFunction

Model schema container class for PartitionFunction

PartitionScheme

Model schema container class for PartitionScheme

PartitionScheme.FilegroupsRelationship

Model schema container class for FilegroupsRelationship

PartitionValue

Model schema container class for PartitionValue

Permission

Model schema container class for Permission

PrimaryKeyConstraint

Model schema container class for PrimaryKeyConstraint

PrimaryKeyConstraint.ColumnsRelationship

Model schema container class for ColumnsRelationship

Procedure

Model schema container class for Procedure

PromotedNodePathForSqlType

Model schema container class for PromotedNodePathForSqlType

PromotedNodePathForXQueryType

Model schema container class for PromotedNodePathForXQueryType

Queue

Model schema container class for Queue

QueueEventNotification

Model schema container class for QueueEventNotification

RemoteServiceBinding

Model schema container class for RemoteServiceBinding

ResourceGovernor

Model schema container class for ResourceGovernor

ResourcePool

Model schema container class for ResourcePool

Role

Model schema container class for Role

RoleMembership

Model schema container class for RoleMembership

Route

Model schema container class for Route

Rule

Model schema container class for Rule

ScalarFunction

Model schema container class for ScalarFunction

Schema

Model schema container class for Schema

SearchProperty

Model schema container class for SearchProperty

SearchPropertyList

Model schema container class for SearchPropertyList

SecurityPolicy

Model schema container class for SecurityPolicy

SecurityPredicate

Model schema container class for SecurityPredicate

SelectiveXmlIndex

Model schema container class for SelectiveXmlIndex

Sequence

Model schema container class for Sequence

ServerAudit

Model schema container class for ServerAudit

ServerAuditSpecification

Model schema container class for ServerAuditSpecification

ServerDdlTrigger

Model schema container class for ServerDdlTrigger

ServerEventNotification

Model schema container class for ServerEventNotification

ServerOptions

Model schema container class for ServerOptions

ServerRoleMembership

Model schema container class for ServerRoleMembership

Service

Model schema container class for Service

ServiceBrokerLanguageSpecifier

Model schema container class for ServiceBrokerLanguageSpecifier

Signature

Model schema container class for Signature

SignatureEncryptionMechanism

Model schema container class for SignatureEncryptionMechanism

SoapLanguageSpecifier

Model schema container class for SoapLanguageSpecifier

SoapMethodSpecification

Model schema container class for SoapMethodSpecification

SpatialIndex

Model schema container class for SpatialIndex

SqlFile

Model schema container class for SqlFile

Statistics

Model schema container class for Statistics

SymmetricKey

Model schema container class for SymmetricKey

SymmetricKeyPassword

Model schema container class for SymmetricKeyPassword

Synonym

Model schema container class for Synonym

Table

Model schema container class for Table

TableType

Model schema container class for TableType

TableTypeCheckConstraint

Model schema container class for TableTypeCheckConstraint

TableTypeColumn

Model schema container class for TableTypeColumn

TableTypeDefaultConstraint

Model schema container class for TableTypeDefaultConstraint

TableTypeIndex

Model schema container class for TableTypeIndex

TableTypePrimaryKeyConstraint

Model schema container class for TableTypePrimaryKeyConstraint

TableTypePrimaryKeyConstraint.ColumnsRelationship

Model schema container class for ColumnsRelationship

TableTypeUniqueConstraint

Model schema container class for TableTypeUniqueConstraint

TableTypeUniqueConstraint.ColumnsRelationship

Model schema container class for ColumnsRelationship

TableValuedFunction

Model schema container class for TableValuedFunction

TcpProtocolSpecifier

Model schema container class for TcpProtocolSpecifier

TSqlModel

Represents a model of a SQL Server database schema.

TSqlModelOptions

Defines model wide options

TSqlModelSchema

Defines a schema for a relational TSQL database model.

TSqlObject

Represents an instance of an object for a SQL Server database schema.

TSqlObjectOptions

Defines options to be used for specific TSqlObjects

UniqueConstraint

Model schema container class for UniqueConstraint

UniqueConstraint.ColumnsRelationship

Model schema container class for ColumnsRelationship

User

Model schema container class for User

UserDefinedServerRole

Model schema container class for UserDefinedServerRole

UserDefinedType

Model schema container class for UserDefinedType

View

Model schema container class for View

WorkloadGroup

Model schema container class for WorkloadGroup

XmlIndex

Model schema container class for XmlIndex

XmlNamespace

Model schema container class for XmlNamespace

XmlSchemaCollection

Model schema container class for XmlSchemaCollection

Enums

AssemblyPermissionSet

Possible permission sets for an assembly

AsymmetricKeyAlgorithm

Algorithm for an asymmetric keys

AuditActionGroupType

SQL Server audit action groups

AuditTarget

SQL Server audit targets

AuthenticationModes

SQL Server 2005 authentication mode

AuthenticationType

Database user Authentication type

CatalogCollation

Catalog collation types

ChangeTrackingOption

Change tracking options

CharacterSet

Possible character sets for SOAP endpoints

ColumnGeneratedAlwaysType

Column system-versioned generated always type

ColumnType

Specifies the type of Column a TSqlObject represents

CompressionLevel

Compression level for data

Containment

Database Containment types

DacExternalQueryScopes

Defines the type of objects to query from the model.

DacQueryScopes

Defines the type of objects to query from the model.

DatabaseAuditAction

Database-level auditable action

DatabaseMirroringRole

Database mirroring role types for SQL Server 2005

DataSourceType

External data source type options

Degree

Grid density level in spatial index

DelayedDurabilityMode

Database Delayed Durability mode

Durability

Durability of a table

ElementNameStyle

Defines the different naming styles supported by the display services

EncryptionMode

Encryption mode for service broker endpoints

EscapeStyle

Enum to specify escape style for displaying model name

EventGroupType

Sql event groups

EventRetentionMode

Event retention mode for event session

EventSessionScope

Scope of the event session

EventType

Sql Server event types

FailureAction

Action type for audit failure

FileFormatType

External file format type options.

ForeignKeyAction

Actions taken when a key to which existing foreign key points is updated or deleted

FunctionType

Specifies the type of Function a TSqlObject represents

HttpPorts

Listening port types associated with an endpoint.

LockEscalationMethod

The types of lock escalation methods

LoginEncryptionOption

SQL login encryption options

MemoryPartitionMode

Memory partion mode for event session

MemoryUnit

Memory units for use in SQL models

MessageSentBy

Specifies message sender type

ModelErrorSeverity

Represents the severity level of the model error

ModelErrorType

The model error type. Represents the various classification of model blocking errors.

NonTransactedFileStreamAccess

FILESTREAM non-transactional access option values

OrderRestriction

Trigger oder restriction types

PageVerifyMode

Database page verify mode for SQL Server 2005

ParameterizationOption

Parameterization options for database

PartitionRange

Specifies to which side of interval, left or right, the boundary value belongs

Payload

Payload types for endpoints

PermissionAction

SQL permission action types

PermissionType

Sql permissions

Protocol

Protocol types for endpoints

QueryStoreCaptureMode

Query Store SIZE_BASED_CLEANUP_MODE option values

QueryStoreDesiredState

Query Store Operation Mode/Desired State option values

RecoveryMode

Database recovery mode

RejectType

External table reject type options.

RelationshipType

Relationship types.

SamplingStyle

Sampling styles used to create statistics

SecondaryXmlIndexType

Types of secondary XML index

SecurityPredicateOperation

The operation to which a security predicate applies

SecurityPredicateType

The type of the security predicate

ServiceBrokerEncryptionAlgorithm

Possible encryption algorithm options for service broker endpoints

ServiceBrokerOption

Possible service broker options for database

SoapFormat

Possible webmethod formats for SOAP endpoints

SoapLoginType

Possible values for LOGIN_TYPE option in SOAP endpoint

SoapSchema

Possible schema options for webmethods in SOAP endpoints

SqlDataType

SQL Server built-in data types

SqlServerVersion

Specific SQL Server releases.

State

State of the endpoint

SymmetricKeyAlgorithm

Algorithms used for symmetric keys

SymmetricKeyCreationDisposition

Asymmetric key creation disposition

TableTypeColumnType

Specifies the type of TableTypeColumn a TSqlObject represents

Tessellation

Grid tessellation in spatial index

TimeUnit

Describes the unit for retention period.

TriggerType

Trigger types

TSqlPlatforms

Specific SQL Server releases.

UserAccessOption

User access mode for the database

UserType

User type (for use with Azure active directory users).

ValidationMethod

Specifies message validation method

XmlStyle

XML data type style