Microsoft.SqlServer.Dac.Model Namespace

 

The Microsoft.SqlServer.Dac.Model namespace contains class that manage the model.

ClassDescription
System_CAPS_pubclassAggregate

Model schema container class for Aggregate

System_CAPS_pubclassApplicationRole

Model schema container class for ApplicationRole

System_CAPS_pubclassAssembly

Model schema container class for Assembly

System_CAPS_pubclassAssemblySource

Model schema container class for AssemblySource

System_CAPS_pubclassAsymmetricKey

Model schema container class for AsymmetricKey

System_CAPS_pubclassAuditAction

Model schema container class for AuditAction

System_CAPS_pubclassAuditActionGroup

Model schema container class for AuditActionGroup

System_CAPS_pubclassAuditActionSpecification

Model schema container class for AuditActionSpecification

System_CAPS_pubclassBrokerPriority

Model schema container class for BrokerPriority

System_CAPS_pubclassBuiltInServerRole

Model schema container class for BuiltInServerRole

System_CAPS_pubclassCertificate

Model schema container class for Certificate

System_CAPS_pubclassCheckConstraint

Model schema container class for CheckConstraint

System_CAPS_pubclassClrTypeMethod

Model schema container class for ClrTypeMethod

System_CAPS_pubclassClrTypeMethodParameter

Model schema container class for ClrTypeMethodParameter

System_CAPS_pubclassClrTypeProperty

Model schema container class for ClrTypeProperty

System_CAPS_pubclassColumn

Model schema container class for Column

System_CAPS_pubclassColumnStoreIndex.ColumnsRelationship

Model schema container class for ColumnsRelationship

System_CAPS_pubclassIndex.ColumnsRelationship

Model schema container class for ColumnsRelationship

System_CAPS_pubclassPrimaryKeyConstraint.ColumnsRelationship

Model schema container class for ColumnsRelationship

System_CAPS_pubclassTableTypePrimaryKeyConstraint.ColumnsRelationship

Model schema container class for ColumnsRelationship

System_CAPS_pubclassTableTypeUniqueConstraint.ColumnsRelationship

Model schema container class for ColumnsRelationship

System_CAPS_pubclassUniqueConstraint.ColumnsRelationship

Model schema container class for ColumnsRelationship

System_CAPS_pubclassColumnStoreIndex

Model schema container class for ColumnStoreIndex

System_CAPS_pubclassContract

Model schema container class for Contract

System_CAPS_pubclassCredential

Model schema container class for Credential

System_CAPS_pubclassCryptographicProvider

Model schema container class for CryptographicProvider

System_CAPS_pubclassDacModelException

Represents the exception thrown from DAC model errors.

System_CAPS_pubclassDacModelMessage

Represents an error or a warning raised during model validation.

System_CAPS_pubclassDatabaseAuditSpecification

Model schema container class for DatabaseAuditSpecification

System_CAPS_pubclassDatabaseDdlTrigger

Model schema container class for DatabaseDdlTrigger

System_CAPS_pubclassDatabaseEncryptionKey

Model schema container class for DatabaseEncryptionKey

System_CAPS_pubclassDatabaseEventNotification

Model schema container class for DatabaseEventNotification

System_CAPS_pubclassDatabaseMirroringLanguageSpecifier

Model schema container class for DatabaseMirroringLanguageSpecifier

System_CAPS_pubclassDatabaseOptions

Model schema container class for DatabaseOptions

System_CAPS_pubclassDataCompressionOption

Model schema container class for DataCompressionOption

System_CAPS_pubclassDataType

Model schema container class for DataType

System_CAPS_pubclassDefault

Model schema container class for Default

System_CAPS_pubclassDefaultConstraint

Model schema container class for DefaultConstraint

System_CAPS_pubclassDisplayServices

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

System_CAPS_pubclassDmlTrigger

Model schema container class for DmlTrigger

System_CAPS_pubclassEndpoint

Model schema container class for Endpoint

System_CAPS_pubclassErrorMessage

Model schema container class for ErrorMessage

System_CAPS_pubclassEventGroup

Model schema container class for EventGroup

System_CAPS_pubclassEventSession

Model schema container class for EventSession

System_CAPS_pubclassEventSessionAction

Model schema container class for EventSessionAction

System_CAPS_pubclassEventSessionDefinitions

Model schema container class for EventSessionDefinitions

System_CAPS_pubclassEventSessionSetting

Model schema container class for EventSessionSetting

System_CAPS_pubclassEventSessionTarget

Model schema container class for EventSessionTarget

System_CAPS_pubclassEventTypeSpecifier

Model schema container class for EventTypeSpecifier

System_CAPS_pubclassExtendedProcedure

Model schema container class for ExtendedProcedure

System_CAPS_pubclassExtendedProperty

Model schema container class for ExtendedProperty

System_CAPS_pubclassFilegroup

Model schema container class for Filegroup

System_CAPS_pubclassPartitionScheme.FilegroupsRelationship

Model schema container class for FilegroupsRelationship

System_CAPS_pubclassFileTable

Model schema container class for FileTable

System_CAPS_pubclassForeignKeyConstraint

Model schema container class for ForeignKeyConstraint

System_CAPS_pubclassFullTextCatalog

Model schema container class for FullTextCatalog

System_CAPS_pubclassFullTextIndex

Model schema container class for FullTextIndex

System_CAPS_pubclassFullTextIndexColumnSpecifier

Model schema container class for FullTextIndexColumnSpecifier

System_CAPS_pubclassFullTextStopList

Model schema container class for FullTextStopList

System_CAPS_pubclassHttpProtocolSpecifier

Model schema container class for HttpProtocolSpecifier

System_CAPS_pubclassIndex

Model schema container class for Index

System_CAPS_pubclassLinkedServer

Model schema container class for LinkedServer

System_CAPS_pubclassLinkedServerLogin

Model schema container class for LinkedServerLogin

System_CAPS_pubclassLogin

Model schema container class for Login

System_CAPS_pubclassMasterKey

Model schema container class for MasterKey

System_CAPS_pubclassContract.MessagesRelationship

Model schema container class for MessagesRelationship

System_CAPS_pubclassMessageType

Model schema container class for MessageType

System_CAPS_pubclassModelCollationComparer

Represents a 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.

System_CAPS_pubclassModelLoadOptions

Represents the 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.

System_CAPS_pubclassModelMetadataClass

The metadata class for metadata properties.

System_CAPS_pubclassModelPropertyClass

Represents the metadata class for properties.

System_CAPS_pubclassModelRelationshipClass

The metadata class for relationships.

System_CAPS_pubclassModelRelationshipInstance

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

System_CAPS_pubclassModelSchema

Model schema for TSqlModel

System_CAPS_pubclassModelTypeClass

The metadata class for TSqlObjects.

System_CAPS_pubclassObjectIdentifier

Represents the object identifier to identify the name of the model.

System_CAPS_pubclassTableValuedFunction.OrderColumnsRelationship

Model schema container class for OrderColumnsRelationship

System_CAPS_pubclassParameter

Model schema container class for Parameter

System_CAPS_pubclassPartitionFunction

Model schema container class for PartitionFunction

System_CAPS_pubclassPartitionScheme

Model schema container class for PartitionScheme

System_CAPS_pubclassPartitionValue

Model schema container class for PartitionValue

System_CAPS_pubclassPermission

Model schema container class for Permission

System_CAPS_pubclassPrimaryKeyConstraint

Model schema container class for PrimaryKeyConstraint

System_CAPS_pubclassProcedure

Model schema container class for Procedure

System_CAPS_pubclassPromotedNodePathForSqlType

Model schema container class for PromotedNodePathForSqlType

System_CAPS_pubclassPromotedNodePathForXQueryType

Model schema container class for PromotedNodePathForXQueryType

System_CAPS_pubclassQueue

Model schema container class for Queue

System_CAPS_pubclassQueueEventNotification

Model schema container class for QueueEventNotification

System_CAPS_pubclassRemoteServiceBinding

Model schema container class for RemoteServiceBinding

System_CAPS_pubclassResourceGovernor

Model schema container class for ResourceGovernor

System_CAPS_pubclassResourcePool

Model schema container class for ResourcePool

System_CAPS_pubclassRole

Model schema container class for Role

System_CAPS_pubclassRoleMembership

Model schema container class for RoleMembership

System_CAPS_pubclassRoute

Model schema container class for Route

System_CAPS_pubclassRule

Model schema container class for Rule

System_CAPS_pubclassScalarFunction

Model schema container class for ScalarFunction

System_CAPS_pubclassSchema

Model schema container class for Schema

System_CAPS_pubclassSearchProperty

Model schema container class for SearchProperty

System_CAPS_pubclassSearchPropertyList

Model schema container class for SearchPropertyList

System_CAPS_pubclassSelectiveXmlIndex

Model schema container class for SelectiveXmlIndex

System_CAPS_pubclassSequence

Model schema container class for Sequence

System_CAPS_pubclassServerAudit

Model schema container class for ServerAudit

System_CAPS_pubclassServerAuditSpecification

Model schema container class for ServerAuditSpecification

System_CAPS_pubclassServerDdlTrigger

Model schema container class for ServerDdlTrigger

System_CAPS_pubclassServerEventNotification

Model schema container class for ServerEventNotification

System_CAPS_pubclassServerOptions

Model schema container class for ServerOptions

System_CAPS_pubclassServerRoleMembership

Model schema container class for ServerRoleMembership

System_CAPS_pubclassService

Model schema container class for Service

System_CAPS_pubclassServiceBrokerLanguageSpecifier

Model schema container class for ServiceBrokerLanguageSpecifier

System_CAPS_pubclassSignature

Model schema container class for Signature

System_CAPS_pubclassSignatureEncryptionMechanism

Model schema container class for SignatureEncryptionMechanism

System_CAPS_pubclassSoapLanguageSpecifier

Model schema container class for SoapLanguageSpecifier

System_CAPS_pubclassSoapMethodSpecification

Model schema container class for SoapMethodSpecification

System_CAPS_pubclassSpatialIndex

Model schema container class for SpatialIndex

System_CAPS_pubclassSqlFile

Model schema container class for SqlFile

System_CAPS_pubclassStatistics

Model schema container class for Statistics

System_CAPS_pubclassSymmetricKey

Model schema container class for SymmetricKey

System_CAPS_pubclassSymmetricKeyPassword

Model schema container class for SymmetricKeyPassword

System_CAPS_pubclassSynonym

Model schema container class for Synonym

System_CAPS_pubclassTable

Model schema container class for Table

System_CAPS_pubclassTableType

Model schema container class for TableType

System_CAPS_pubclassTableTypeCheckConstraint

Model schema container class for TableTypeCheckConstraint

System_CAPS_pubclassTableTypeColumn

Model schema container class for TableTypeColumn

System_CAPS_pubclassTableTypeDefaultConstraint

Model schema container class for TableTypeDefaultConstraint

System_CAPS_pubclassTableTypeIndex

Model schema container class for TableTypeIndex

System_CAPS_pubclassTableTypePrimaryKeyConstraint

Model schema container class for TableTypePrimaryKeyConstraint

System_CAPS_pubclassTableTypeUniqueConstraint

Model schema container class for TableTypeUniqueConstraint

System_CAPS_pubclassTableValuedFunction

Model schema container class for TableValuedFunction

System_CAPS_pubclassTcpProtocolSpecifier

Model schema container class for TcpProtocolSpecifier

System_CAPS_pubclassTSqlModel

Represents a model of a SQL Server database schema.

System_CAPS_pubclassTSqlModelOptions

Defines model wide options

System_CAPS_pubclassTSqlModelSchema

Defines a schema for a relational TSQL database model.

System_CAPS_pubclassTSqlObject

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

System_CAPS_pubclassTSqlObjectOptions

Defines options to be used for specific TSqlObjects.

System_CAPS_pubclassUniqueConstraint

Model schema container class for UniqueConstraint

System_CAPS_pubclassUser

Model schema container class for User

System_CAPS_pubclassUserDefinedServerRole

Model schema container class for UserDefinedServerRole

System_CAPS_pubclassUserDefinedType

Model schema container class for UserDefinedType

System_CAPS_pubclassView

Model schema container class for View

System_CAPS_pubclassWorkloadGroup

Model schema container class for WorkloadGroup

System_CAPS_pubclassXmlIndex

Model schema container class for XmlIndex

System_CAPS_pubclassXmlNamespace

Model schema container class for XmlNamespace

System_CAPS_pubclassXmlSchemaCollection

Model schema container class for XmlSchemaCollection

EnumerationDescription
System_CAPS_pubenumAssemblyPermissionSet

Possible permission sets for an assembly

System_CAPS_pubenumAsymmetricKeyAlgorithm

Algorithm for an asymmetric keys

System_CAPS_pubenumAuditActionGroupType

SQL Server audit action groups

System_CAPS_pubenumAuditTarget

SQL Server audit targets

System_CAPS_pubenumAuthenticationModes

SQL Server 2005 authentication mode

System_CAPS_pubenumAuthenticationType

Database user Authentication type

System_CAPS_pubenumChangeTrackingOption

Change tracking options

System_CAPS_pubenumCharacterSet

Possible character sets for SOAP endpoints

System_CAPS_pubenumColumnType

Specifies the type of Column a TSqlObject represents

System_CAPS_pubenumCompressionLevel

Compression level for data

System_CAPS_pubenumContainment

Database Containment types

System_CAPS_pubenumDacExternalQueryScopes

Defines the type of objects to query from the model.

System_CAPS_pubenumDacQueryScopes

Defines the type of objects to query from the model.

System_CAPS_pubenumDatabaseAuditAction

Database-level auditable action

System_CAPS_pubenumDatabaseMirroringRole

Database mirroring role types for SQL Server 2005

System_CAPS_pubenumDegree

Grid density level in spatial index

System_CAPS_pubenumDelayedDurabilityMode

Database Delayed Durability mode

System_CAPS_pubenumDurability

Durability of a table

System_CAPS_pubenumElementNameStyle

Defines the different naming styles supported by the display services

System_CAPS_pubenumEncryptionMode

Encryption mode for service broker endpoints

System_CAPS_pubenumEscapeStyle

Enum to specify escape style for displaying model name

System_CAPS_pubenumEventGroupType

Sql event groups

System_CAPS_pubenumEventRetentionMode

Event retention mode for event session

System_CAPS_pubenumEventType

Sql Server event types

System_CAPS_pubenumFailureAction

Action type for audit failure

System_CAPS_pubenumForeignKeyAction

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

System_CAPS_pubenumFunctionType

Specifies the type of Function a TSqlObject represents

System_CAPS_pubenumHttpPorts

Listening port types associated with an endpoint.

System_CAPS_pubenumLockEscalationMethod

The types of lock escalation methods

System_CAPS_pubenumLoginEncryptionOption

SQL login encryption options

System_CAPS_pubenumMemoryPartitionMode

Memory partion mode for event session

System_CAPS_pubenumMemoryUnit

Memory units for use in SQL models

System_CAPS_pubenumMessageSentBy

Specifies message sender type

System_CAPS_pubenumNonTransactedFileStreamAccess

FILESTREAM non-transactional access option values

System_CAPS_pubenumOrderRestriction

Trigger oder restriction types

System_CAPS_pubenumPageVerifyMode

Database page verify mode for SQL Server 2005

System_CAPS_pubenumParameterizationOption

Parameterization options for database

System_CAPS_pubenumPartitionRange

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

System_CAPS_pubenumPayload

Payload types for endpoints

System_CAPS_pubenumPermissionAction

SQL permission action types

System_CAPS_pubenumPermissionType

Sql permissions

System_CAPS_pubenumProtocol

Protocol types for endpoints

System_CAPS_pubenumRecoveryMode

Database recovery mode

System_CAPS_pubenumRelationshipType

Relationship types.

System_CAPS_pubenumSamplingStyle

Sampling styles used to create statistics

System_CAPS_pubenumSecondaryXmlIndexType

Types of secondary XML index

System_CAPS_pubenumServiceBrokerEncryptionAlgorithm

Possible encryption algorithm options for service broker endpoints

System_CAPS_pubenumServiceBrokerOption

Possible service broker options for database

System_CAPS_pubenumSoapFormat

Possible webmethod formats for SOAP endpoints

System_CAPS_pubenumSoapLoginType

Possible values for LOGIN_TYPE option in SOAP endpoint

System_CAPS_pubenumSoapSchema

Possible schema options for webmethods in SOAP endpoints

System_CAPS_pubenumSqlDataType

SQL Server built-in data types

System_CAPS_pubenumSqlServerVersion

Specific SQL Server releases.

System_CAPS_pubenumState

State of the endpoint

System_CAPS_pubenumSymmetricKeyAlgorithm

Algorithms used for symmetric keys

System_CAPS_pubenumSymmetricKeyCreationDisposition

Asymmetric key creation disposition

System_CAPS_pubenumTableTypeColumnType

Specifies the type of TableTypeColumn a TSqlObject represents

System_CAPS_pubenumTessellation

Grid tessellation in spatial index

System_CAPS_pubenumTimeUnit

Describes the unit for retention period.

System_CAPS_pubenumTriggerType

Trigger types

System_CAPS_pubenumTSqlPlatforms

Specific SQL Server releases.

System_CAPS_pubenumUserAccessOption

User access mode for the database

System_CAPS_pubenumValidationMethod

Specifies message validation method

System_CAPS_pubenumXmlStyle

XML data type style

Return to top

Community Additions

ADD
Show: