Spazio dei nomi Microsoft.SqlServer.Management.Dmf

The Microsoft.SqlServer.Management.Dmf namespace contains classes that represent the SQL Server policy-based management objects. 

The top-level instance is the PolicyStore class, which proves the connection to the instance of SQL Server. The other : Policy, Condition, PolicyGroupSubscription, PolicyCategory, Facets.

The DMF objects can be used to create and manage policies that control the behavior and configuration of an instance of SQL Server. All behavior and configurations are represented by facets. The Microsoft.SqlServer.Management.Facets namespace contains the objects that represent the repository of facets used when defining policies. Policies are used when defining a DAC package using the DAC objects. This enables you control policies when installing a database application structure stored in the DAC package onto an instance of SQL Server. The specified policies determine the instances of SQL Server in the SQL Fabric to which the DAC package can be deployed.

A policy is the result of applying a condition to one of more target object. The condition is a facet combined with a state of behavior, for example, Database Mail is the facet and whether it is installed or not is the state. So, specifying that Database Mail must be installed is a condition. You can create a target set of objects by applying a filter. Then, apply the condition to the target object set to make a policy.

The Microsoft.SqlServer.Management.Dmf namespace resides in the Microsoft.SqlServer.Dmf.dll file. Additionally, some supporting objects are in the Microsoft.SqlServer.DmfSqlClrWrapper.dll and Microsoft.SqlServer.Dmf.Adapters.dll files. You will have to import these files to access the classes in the Microsoft.SqlServer.Management.Dmf namespace.

By using the Microsoft.SqlServer.Management.Dmf namespace, you can do the following:

  • Create, read, update and delete policies, target objects, conditions, filters and subscriptions.

  • Script out the DMF objects associated with the connection.

  • Define a target object set by using a filter.

  • Extract the existing configuration state from an instance of SQL Server and create a policy.

  • Export and import DMF objects.

  • Assign a policy to a set of target objects.

  • Evaluate a policy.

  • Have target subscribe to policy.

Classi

  Classe Descrizione
Classe pubblica AdapterAlreadyExistsException The AdapterAlreadyExistsException class is an exception that is raised when an attempt is made to retrieve a collection that is not available.
Classe pubblica AdapterWrongNumberOfArgumentsException The AdapterWrongNumberOfArgumentsException class is an exception that is raised when the adapter receives the wrong number of arguments.
Classe pubblica AssemblyAlreadyRegisteredException The AssemblyAlreadyRegistered class is an exception that is raised when an the adapter receives the wrong number of arguments.
Classe pubblica BadEventDataException The BadEventDataException class is an exception that is raised when the event data is incorrect.
Classe pubblica BadExpressionTreeException The BadExpressionTreeException class is an exception that is raised when the expression tree is incorrect.
Classe pubblica Condition The Condition object represents a policy-based management condition.
Classe pubblica Condition. . :: . .Key The Condition..::..Key class represents the key that identifies the Condition class.
Classe pubblica ConditionCollection The ConditionCollection class represents a collection of Condition objects that represent all the conditions in the policy store.
Classe pubblica ConditionExtender The ConditionExtender class is an exception that is raised when the expression tree is incorrect.
Classe pubblica ConflictingPropertyValuesException The ConflictingPropertyValuesException class is an exception that is raised when property values conflict.
Classe pubblica ConnectionEvaluationHistory The ConnectionEvaluationHistory object represents information about parent policy evaluation that is stored in the system catalogs.
Classe pubblica ConnectionEvaluationHistory. . :: . .Key The ConnectionEvaluationHistory..::..Key class represents the key that is used to identify the ConnectionEvaluationHistory class.
Classe pubblica ConnectionEvaluationHistoryCollection The ConnectionEvaluationHistoryCollection class represents a collection of ConnectionEvaluationHistory objects that represent all the connection evaluation histories that are in the evaluation history.
Classe pubblica ConversionNotSupportedException The ConversionNotSupportedException class is an exception that is raised when an unsupported conversion is attempted on a type.
Classe pubblica DmfException The DmfException class represents a generic policy-based management exception.
Classe pubblica EvaluationDetail The EvaluationDetail object represents the evaluation information that is stored in the system catalogs about the parent policy for a given target.
Classe pubblica EvaluationDetail. . :: . .Key The EvaluationDetail..::..Key class represents the key that is used to identify the EvaluationDetail class.
Classe pubblica EvaluationDetailCollection The EvaluationDetailCollection class represents a collection of EvaluationDetail objects that represent all the detail rows that are in the evaluation.
Classe pubblica EvaluationFactory Represents the evaluation factory in policy-based management services.
Classe pubblica EvaluationHistory The EvaluationHistory object represents information about parent policy evaluation that is stored in the system catalogs.
Classe pubblica EvaluationHistory. . :: . .Key The EvaluationHistory..::..Key class represents the key that identifies the EvaluationHistory class.
Classe pubblica EvaluationHistoryCollection The EvaluationHistoryCollection class represents a collection of EvaluationHistory objects that represent all evaluation histories that are in the policy store.
Classe pubblica ExpressionNode The ExpressionNode object represents a policy-based management expression node. The expression node describes part of an expression, such as a constant value, an operator, or a function.
Classe pubblica ExpressionNodeAttribute The ExpressionNodeAttribute object represents an attribute of a policy-based management expression node.
Classe pubblica ExpressionNodeChildren The ExpressionNodeChildren object represents the child expression nodes that are dependent on an expression node.
Classe pubblica ExpressionNodeConfigurationException The ExpressionNodeConfigurationException class is an exception that is raised when the adapter receives the wrong number of arguments.
Classe pubblica ExpressionNodeConstant The ExpressionNodeConstant object represents an constant value that is used in an expression.
Classe pubblica ExpressionNodeFunction The ExpressionNodeFunction object represents part of a policy-based management expression that is a function.
Classe pubblica ExpressionNodeGroup The ExpressionNodeGroup object represents an expression node that is a group.
Classe pubblica ExpressionNodeNotConfigurableException The ExpressionNodeNotConfigurableException class is an exception that is raised when the expression node cannot be configured.
Classe pubblica ExpressionNodeNotConfigurableOperatorException The ExpressionNodeNotConfigurableOperatorException class is an exception that is raised if the operator cannot configure the expression node.
Classe pubblica ExpressionNodeOperator The ExpressionNodeOperator object represents an expression node that is an operator.
Classe pubblica ExpressionSerializationException The ExpressionSerializationException class is an exception that is raised when an the adapter receives the wrong number of arguments.
Classe pubblica ExpressionTypeMistmatchException The ExpressionTypeMismatchException class is an exception that is raised when the types in the expression do not match.
Classe pubblica FacetInfo The FacetInfo object represents facet information. A facet represents a logical dimension of a target object and is used, together with a local expression, to build a condition.
Classe pubblica FacetInfoCollection The FacetInfoCollection class represents a collection of FacetInfo objects that represent all facets on the instance of SQL Server.
Classe pubblica FailedOperationException The FailedOperationException class is an exception that is raised when a policy-based management operation fails.
Classe pubblica FunctionBadDatePartException The FunctionBadDatePartException class is an exception that is raised when the date that is supplied to the function is not the correct format.
Classe pubblica FunctionNoServerException The FunctionNoServerException class is an exception that is raised when the server is not recognized.
Classe pubblica FunctionNotASmoObjectException The FunctionNotASmoObjectException class is an exception that is raised when the function encounters an unsupported object.
Classe pubblica FunctionTooManyColumnsException The FunctionTooManyColumnsException class is an exception that is raised when the function has too many columns.
Classe pubblica FunctionWrongArgumentsNumberException The FunctionWrongArgumentsNumberException class is an exception that is raised when the function receives the incorrect number of arguments.
Classe pubblica FunctionWrongArgumentTypeException The FunctionWrongArgumentTypeException class is an exception that is raised when the function receives an argument that is the incorrect type.
Classe pubblica FunctionWrongReturnTypeException The FunctionWrongReturnTypeException class is an exception that is raised when the specified return type is not the same as the type that is returned by the function.
Classe pubblica InvalidInOperatorException The InvalidInOperatorException class is an exception that is raised when the operator is not valid.
Classe pubblica InvalidOperandException The InvalidOperandException class is an exception that is raised when an operand is encountered that is not valid.
Classe pubblica MissingJobScheduleException The MissingJobScheduleException class is an exception that is raised when there in no job schedule.
Classe pubblica MissingObjectException The MissingObjectException class is an exception that is raised when a specified object is missing.
Classe pubblica MissingPropertyException The MissingPropertyException class is an exception that is raised when a specified property is missing.
Classe pubblica MissingTypeFacetAssociationException The MissingTypeFacetAssociationException class is an exception that is raised when a specified association between a facet and a type is missing.
Classe pubblica NonConfigurableReadOnlyPropertyException The NonConfigurableReadOnlyPropertyException class is an exception that is raised when there is an attempt to configure a read-only property.
Classe pubblica NonRetrievablePropertyException The NonRetrievablePropertyException class is an exception that is raised when a property cannot be retrieved.
Classe pubblica NoTargetSetEnabledException The NoTargetSetEnabledException class is an exception that is raised when the target set has not been enabled.
Classe pubblica NullFacetException The NullFacetException class is an exception that is raised when the facet is not set.
Classe pubblica ObjectAlreadyExistsException The ObjectAlreadyExistsException class is an exception that is raised when an attempt to create an object that already exists is made.
Classe pubblica ObjectSet The ObjectSet object represents a policy-based management set of objects.
Classe pubblica ObjectSet. . :: . .Key The ObjectSet..::..Key class represents the key that identifies the ObjectSet class.
Classe pubblica ObjectSetCollection The ObjectSetCollection class represents a collection of ObjectSet objects that represent all the object sets in the policy store.
Classe pubblica ObjectValidationException The ObjectValidationException class is an exception that is raised when an object encounters an error during validation.
Classe pubblica OperatorNotApplicableException The OperatorNotApplicableException class is an exception that is raised when an operator does not have the appropriate permissions.
Classe pubblica Policy The Policy object represents a Policy-Based Management policy. A policy represents the relationship between a target object and a condition.
Classe pubblica Policy. . :: . .ConnectionProcessingFinishedEventArgs Represents the arguments that are passed to the event handler when the connection processing is finished.
Classe pubblica Policy. . :: . .ConnectionProcessingStartedEventArgs Represents the arguments that are passed to the event handler when the connection processing has started.
Classe pubblica Policy. . :: . .Key The Policy..::..Key class represents the key that identifies each instance of the Policy class.
Classe pubblica Policy. . :: . .PolicyEvaluationFinishedEventArgs Represents the arguments that are passed to the event handler when the evaluation of a policy finishes.
Classe pubblica Policy. . :: . .TargetProcessedEventArgs Represents the arguments that are passed to the event handler when the target is processed.
Classe pubblica PolicyCategory Represents a category that classifies policies in SQL Server Policy-Based Management. Policy Categories are used to group policies together to which target objects can subscribe.
Classe pubblica PolicyCategory. . :: . .Key The PolicyCategory..::..Key class represents the key that identifies the PolicyCategory class.
Classe pubblica PolicyCategoryCollection The PolicyCategoryCollection class represents a collection of PolicyCategory objects that represent all policy categories in the policy store.
Classe pubblica PolicyCategoryInformation Contains information about the policy category in policy-based management services.
Classe pubblica PolicyCategorySubscription The PolicyCategorySubscription object represents a subscription to a particular policy category.
Classe pubblica PolicyCategorySubscription. . :: . .Key The PolicyCategorySubscription..::..Key class represents the key that identifies the PolicyCategorySubscription class.
Classe pubblica PolicyCategorySubscriptionCollection The PolicyCategorySubscriptionCollection class represents a collection of PolicyCategorySubscription objects that represent all policy category subscriptions that are in the policy store.
Classe pubblica PolicyCollection The PolicyCollection class represents a collection of Policy objects that represent all policies in the policy store.
Classe pubblica PolicyEvaluationException The PolicyEvaluationException class is an exception that is raised when an error occurs during the evaluation of a policy.
Classe pubblica PolicyEvaluationResultsWriter Represents the XML writer that records the policy evaluation history in Policy-Based Management.
Classe pubblica PolicyEvaluationWrapper Represents a wrapper class for the policy evaluation.
Classe pubblica PolicyExtender Contains additional functionality for the Policy object.
Classe pubblica PolicyStore The PolicyStore type is the root of the DMF object model.
Classe pubblica PolicyStore. . :: . .Key The PolicyStore..::..Key class represents the key that identifies each instance of the PolicyStore class.
Classe pubblica PolicyStoreUpgradeSession Represents a policy store upgrade session.
Classe pubblica PostConfigurationActionAttribute Represents a set post configuration action attributes.
Classe pubblica RestartPendingException The RestartPendingException class represents the exception that is raised when a system restart is pending.
Classe pubblica RestartPendingException< (Of < ( <'T> ) > ) > The RestartPendingException class is an exception that is raised when an error occurs when a system restart is pending.
Classe pubblica StringPropertyTooLongException The StringPropertyTooLongException class is an exception that is raised when the string that is assigned to a property is too long.
Classe pubblica TargetEvaluation Represents the target evaluation in policy-based management services.
Classe pubblica TargetSet The TargetSet object represents a policy-based Management target set that holds information about levels, the condition for each level, and the target types.
Classe pubblica TargetSet. . :: . .Key The TargetSet..::..Key class represents the key that identifies the TargetSet class.
Classe pubblica TargetSetCollection The TargetSetCollectionCollection class represents a collection of TargetSet objects that represent all the policies in the policy store.
Classe pubblica TargetSetCountMismatchException The TargetSetCountMismatchException class is an exception that is raised when the target set and facet counts do not match.
Classe pubblica TargetSetLevel Represents the target set level in policy-based management services.
Classe pubblica TargetSetLevel. . :: . .Key The TargetSetLevel..::..Key class represents the key that identifies the TargetSetLevel class.
Classe pubblica TargetSetLevelCollection The TargetSetLevelCollection class represents a collection of TargetSetLevel objects that represent all target set levels in the target set.
Classe pubblica TypeConversionException The TypeConversionException class is an exception that is raised when a type conversion error occurs.
Classe pubblica UnsupportedObjectTypeException The UnsupportedObjectTypeException class is an exception that is raised when an error occurs when the policy encounters an unsupported object.
Classe pubblica UnsupportedTargetSetForFacetException The UnsupportedTargetSetForFacetException class is an exception that is raised when an error occurs when the target set is not supported by the facet.
Classe pubblica UnsupportedTypeException The UnsupportedTypeException class is an exception that is raised when an unsupported type is encountered.
Classe pubblica Utils Represents a utility class that is used in policy-based management services.

Delegati

  Delegato Descrizione
Delegato pubblico Policy. . :: . .ConnectionProcessingFinishedEventHandler The Policy..::..ConnectionProcessingFinishedEventHandler class represents the event handler that handles the event that occurs when the processing of the connection has finished.
Delegato pubblico Policy. . :: . .ConnectionProcessingStartedEventHandler The Policy..::..ConnectionProcessingStartedEventHandler class represents the event handler that handles the event that occurs when the processing of a connection has started.
Delegato pubblico Policy. . :: . .PolicyEvaluationFinishedEventHandler Rappresenta gli argomenti passati al gestore dell'evento una volta terminata la valutazione di criteri.
Delegato pubblico Policy. . :: . .PolicyEvaluationStartedEventHandler The PolicyEvaluationStartedEventHandler class represents the event handler that handles the event that occurs when the evaluation of a policy has started.
Delegato pubblico Policy. . :: . .TargetProcessedEventHandler The TargetProcessedEventHandler class represents the event handler that handles the event that occurs when the target has been processed.

Enumerazioni

  Enumerazione Descrizione
Enumerazione pubblica AdHocPolicyEvaluationMode The AdHocPolicyEvaluationMode enumeration contains values that specify the method that is used to evaluate the policy.
Enumerazione pubblica AutomatedPolicyEvaluationMode The AutomatedPolicyEvaluationMode enumeration contains values that specify the Policy-Based Management automated policy evaluation modes.
Enumerazione pubblica DmfExceptionType The DmfExceptionType enumeration contains values that are used to specify the policy-based management exception types.
Enumerazione pubblica ExpressionNodeFunction. . :: . .Function The ExpressionNodeFunction..::..Function enumeration contains values that represent the different types of supported functions.
Enumerazione pubblica ExpressionNodeType The ExpressionNodeType enumeration contains values that specify the type of expression node.
Enumerazione pubblica ExpressionSerializationException. . :: . .ReaderActionType Represents the reader action type that is associated with the serialization. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server.
Enumerazione pubblica ImportPolicyEnabledState L'enumerazione ImportPolicyEnabledState contiene valori utilizzati per specificare lo stato dei criteri di importazione.
Enumerazione pubblica NameConditionType The NameConditionType enumeration contains values that are used to specify the condition that is used in a policy.
Enumerazione pubblica OperatorType The OperatorType enumeration contains values that are used to specify the type of operator.
Enumerazione pubblica PolicyEffectiveState The PolicyEffectiveState enumeration contains values that are used to specify the effectiveness of the policy.
Enumerazione pubblica PolicyHealthState The PolicyHealthState enumeration contains values that specify the health state of the policy.
Enumerazione pubblica PolicyStore. . :: . .EnumerationMode Specifies the enumeration mode for the PolicyStore object.
Enumerazione pubblica PostConfigurationAction The PostConfigurationAction enumeration contains values that specify the action to take after configuration finishes.
Enumerazione pubblica TypeClass The TypeClass enumeration contains values that describe the different class types.