Skip to main content

Dataverse reference

Interfaces

TypeSummary
IBulkOperationExecutorExecutes bulk operations using modern Dataverse APIs.
ICachedMetadataProviderProvides cached access to Dataverse metadata for IntelliSense and entity browsing.
IConnectionSelectionStrategyStrategy for selecting which connection to use from the pool.
IConnectionSourceProvides a seed ServiceClient for the connection pool to clone.
IDataverseClientAbstraction over ServiceClient providing core Dataverse operations.
IDataverseConnectionPoolManages a pool of Dataverse connections with intelligent selection and lifecycle management.
IMetadataAuthoringProgressReporterLightweight progress reporter for metadata authoring operations.
IMetadataQueryExecutorExecutes metadata queries against Dataverse, returning results as QueryRow format.
IMetadataQueryServiceProvides access to Dataverse metadata for entity browsing and discovery.
IPooledClientA client obtained from the connection pool.
IQueryExecutorExecutes FetchXML queries against Dataverse and returns structured results.
IQueryPlanNodeA node in the query execution plan tree (Volcano/iterator model).
IQueryProgressReporterLightweight progress reporter for query plan execution.
IScalarFunctionA scalar function that accepts arguments and returns a single value.
ISourceTokenizerProduces source tokens for syntax highlighting.
ITdsQueryExecutorExecutes SQL queries against Dataverse's TDS Endpoint (read-only replica)
IThrottleTrackerTracks throttle state across connections.

Classes

TypeSummary
AdaptiveAggregateScanNodeWraps a FetchXML aggregate scan with adaptive retry. When the Dataverse
AdaptiveBatchSizerDynamically adjusts DML batch size based on observed execution times.
AdaptiveThrottleManagerDynamically adjusts the degree of parallelism (DOP) for bulk DML operations
AddOptionValueRequestRequest to add a new option value to an existing option set.
AsyncOperationProcess whose execution can proceed independently or in the background.
AttributeMetadataDtoDetailed attribute metadata for entity browsing.
AuthenticationErrorDetectorDetects authentication and authorization failures from Dataverse operations.
BatchCoordinatorExhaustedExceptionThrown when batch coordinator cannot acquire a slot within timeout.
BatchFailureDiagnosticDiagnostic information for identifying the cause of a batch failure.
BatchParallelismCoordinatorCoordinates batch parallelism across all concurrent bulk operations.
BulkOperationErrorError details for a failed record in a bulk operation.
BulkOperationErrorCodeStructured error codes for bulk operation validation failures.
BulkOperationExecutorExecutes bulk operations using modern Dataverse APIs.
BulkOperationOptionsConfiguration options for bulk operations.
BulkOperationValidationExceptionException thrown when bulk operation configuration fails validation.
CachedMetadataProviderProvides cached access to Dataverse metadata, wrapping PPDS.Dataverse.Metadata.IMetadataQueryService
CascadeConfigurationDtoDefines the cascade behavior configuration for a relationship.
CastConverterImplements T-SQL CAST/CONVERT type conversion semantics.
ClientAggregateColumnDescribes an aggregate column for client-side computation.
ClientAggregateNodeComputes aggregate functions client-side from raw (non-aggregated) input rows.
ClientFilterNodeFilters rows by evaluating a condition client-side.
ClientWindowNodeComputes window functions (ROW_NUMBER, RANK, DENSE_RANK, aggregate OVER) client-side.
CompiledPredicateCompiled predicate: evaluates against a row and returns true/false.
CompiledScalarExpressionCompiled scalar expression: evaluates against a row and returns a value.
ConcatenateNodeConcatenates rows from multiple child nodes sequentially.
ConfigurationExceptionException thrown when Dataverse configuration is invalid.
ConnectionPoolOptionsConfiguration options for the Dataverse connection pool.
ConnectionStatisticsStatistics for a specific connection configuration.
ConnectionStringBuilderBuilds Dataverse connection strings from typed configuration.
ConnectionStringRedactorProvides utilities for redacting sensitive information from connection strings
ConnectionStringSourceConnection source that creates a ServiceClient from connection string configuration.
CorrelationIdScopeAmbient correlation-ID scope shared by the CLI, the RPC daemon, and every
CreateChoiceResultResult of a create global choice operation.
CreateColumnRequestRequest to create a new column (attribute) on a Dataverse table.
CreateColumnResultResult of a create column operation.
CreateGlobalChoiceRequestRequest to create a new global choice (option set) in Dataverse.
CreateKeyRequestRequest to create an alternate key on a Dataverse table.
CreateKeyResultResult of a create alternate key operation.
CreateManyToManyRequestRequest to create a many-to-many (N:N) relationship between two Dataverse tables.
CreateOneToManyRequestRequest to create a one-to-many (1:N) relationship between two Dataverse tables.
CreateRelationshipResultResult of a create relationship operation.
CreateTableRequestRequest to create a new Dataverse table (entity).
CreateTableResultResult of a create table operation.
CustomAPIEntity that defines a custom API
CustomAPIRequestParameterEntity that defines a request parameter for a custom API
CustomAPIResponsePropertyEntity that defines a response property for a custom API
DataverseAuthenticationExceptionException thrown when a Dataverse operation fails due to authentication or authorization issues.
DataverseClientImplementation of PPDS.Dataverse.Client.IDataverseClient that wraps a Microsoft.PowerPlatform.Dataverse.Client.ServiceClient.
DataverseClientOptionsOptions for configuring a Dataverse client request.
DataverseConnectionConfiguration for a Dataverse connection (Application User / Service Principal).
DataverseConnectionExceptionException thrown when a Dataverse connection fails.
DataverseConnectionPoolHigh-performance connection pool for Dataverse with multi-connection support.
DataverseEnvironmentOptionsConfiguration for a named Dataverse environment.
DataverseFunctionsDataverse-specific functions evaluated client-side.
DataverseMetadataQueryServiceProvides access to Dataverse metadata using the SDK.
DataverseOptionsRoot configuration options for Dataverse connection pooling and operations.
DateFunctionsT-SQL date/time functions evaluated client-side.
DateRangePartitionA single date range partition with non-overlapping boundaries.
DateRangePartitionerGenerates non-overlapping date range partitions for splitting aggregate queries
DeleteColumnRequestRequest to delete a column (attribute) from a Dataverse table.
DeleteDryRunResultResult of a delete dry-run operation, listing dependencies that would block deletion.
DeleteGlobalChoiceRequestRequest to delete a global choice (option set) from Dataverse.
DeleteKeyRequestRequest to delete an alternate key from a Dataverse table.
DeleteOptionValueRequestRequest to delete an option value from an option set.
DeleteRelationshipRequestRequest to delete a Dataverse relationship.
DeleteTableRequestRequest to delete a Dataverse table (entity).
DependencyInfoDescribes a single component dependency found during a delete dry-run.
DistinctNodeDeduplicates rows from a single input using a composite key hash set.
DmlExecuteNodeExecutes DML operations (INSERT, UPDATE, DELETE) using BulkOperationExecutor.
DmlValueCoercerCoerces raw CLR values from SQL DML into Dataverse SDK-typed values
EntityDataProviderDevelopers can register plug-ins on a data provider to enable data access for virtual entities in the system.
EntityKeyDtoRepresents an alternate key definition for an entity.
EntityMetadataDtoFull entity metadata including attributes, relationships, keys, and privileges.
EntityRelationshipsDtoContainer for all relationship types for an entity.
EntitySummarySummary information for an entity in list views.
EnvironmentResolverResolves named environments from DataverseOptions.
EnvironmentVariableDefinitionContains information about the settable variable: its type, default value, and etc.
EnvironmentVariableValueHolds the value for the associated EnvironmentVariableDefinition entity.
ErrorFunctionsT-SQL error functions for TRY/CATCH blocks.
FetchXmlScanNodeExecutes a FetchXML query and yields rows page-by-page.
FunctionRegistryRegistry of scalar functions available for expression evaluation.
ImportJobFor internal use only.
JsonFunctionsT-SQL JSON functions evaluated client-side using System.Text.Json.
LeastConnectionsStrategySelects the connection with the fewest active clients.
ListResult<T>Wraps a list result with metadata about the total dataset.
ManyToManyRelationshipDtoRepresents a many-to-many relationship.
MathFunctionsT-SQL math functions evaluated client-side.
MergeAggregateColumnDescribes an aggregate column to be merged.
MergeAggregateNodeMerges partial aggregate results from parallel partitions.
MetadataErrorCodesMachine-readable error codes for metadata authoring validation failures.
MetadataQueryExecutorQueries Dataverse metadata via PPDS.Dataverse.Metadata.IMetadataQueryService and returns results
MetadataScanNodeScan node that queries Dataverse metadata API instead of entity data.
MetadataTableDefinitionsDefines the schema of metadata virtual tables.
MetadataValidationExceptionThrown when metadata authoring validation fails.
NodeStatisticsStatistics for a single plan node. Thread-safe via Interlocked operations.
NullFunctionsT-SQL null-handling functions evaluated client-side.
OptionDefinitionDefines a single option value for a choice or choices column.
OptionSetMetadataDtoFull option set metadata including all values.
OptionSetSummarySummary information for a global option set in list views.
OptionValueDtoRepresents a single option value in an option set.
ParallelPartitionNodeExecutes child plan nodes in parallel, limited by pool capacity.
PlanExecutorExecutes a query plan by consuming the root node's IAsyncEnumerable
PlanFormatterFormats an execution plan tree as indented text for EXPLAIN output.
PluginAssemblyAssembly that contains one or more plug-in types.
PluginTraceLogTrace and exception information generated by plug-ins and custom workflow activities.
PluginTypeType that inherits from the IPlugin interface and is contained within a plug-in assembly.
PoolExhaustedExceptionException thrown when the connection pool is exhausted and no connection
PoolStatisticsStatistics and health information for the connection pool.
PooledClientExtensionsExtension methods on PPDS.Dataverse.Pooling.IPooledClient for common Dataverse SDK operations
PrefetchScanNodeWraps any IQueryPlanNode to speculatively prefetch rows into a bounded buffer.
PrivilegeDtoRepresents a security privilege for an entity.
ProgressSnapshotImmutable snapshot of progress state at a point in time.
ProgressTrackerThread-safe progress tracker for bulk operations.
ProjectColumnDefines a column in a ProjectNode's output.
ProjectNodeMaps input rows to output rows (column selection, renaming, expression evaluation).
PublisherA publisher of a CRM solution.
QueryColumnRepresents a column in a query result with its metadata.
QueryErrorCodeStructured error codes for query execution failures.
QueryExecutionExceptionException thrown during query plan execution with a structured error code.
QueryExecutorExecutes FetchXML queries against Dataverse using the connection pool.
QueryPlanContextShared context for plan execution: pool, cancellation, statistics.
QueryPlanDescriptionDescribes an execution plan for display (EXPLAIN output).
QueryPlanOptionsOptions for query plan construction.
QueryPlanResultThe result of building an execution plan: the root plan node plus metadata
QueryPlanStatisticsMutable statistics collected during plan execution.
QueryResultRepresents the result of a query execution against Dataverse.
QueryRowA single row flowing through the plan. Lightweight wrapper around column values.
QueryValueRepresents a value in a query result, including both the raw value
ReactivateKeyRequestRequest to reactivate a failed alternate key on a Dataverse table.
RelationshipMetadataDtoRepresents a one-to-many or many-to-one relationship.
RemoteScanNodeExecutes a FetchXML query against a remote environment's connection pool.
ReorderOptionsRequestRequest to reorder the option values in an option set.
ResilienceOptionsConfiguration options for resilience and retry behavior.
RoleGrouping of security privileges. Users are assigned roles that authorize their access to the Microsoft CRM system.
RoundRobinStrategySimple round-robin rotation through available connections.
SchemaValidatorValidates metadata authoring requests before SDK calls.
SdkMessageMessage that is supported by the SDK.
SdkMessageFilterFilter that defines which SDK messages are valid for each type of entity.
SdkMessageProcessingStepStage in the execution pipeline that a plug-in is to execute.
SdkMessageProcessingStepImageCopy of an entity's attributes before or after the core system operation.
SecretResolverResolves secrets from various sources.
SeedInitializationResultResult of initializing a seed connection for a pool source.
SensitiveDataAttributeMarks a property or field as containing sensitive data that should not be logged or displayed.
ServiceClientSourceConnection source for pre-authenticated ServiceClients.
ServiceCollectionExtensionsExtension methods for configuring Dataverse services in an Microsoft.Extensions.DependencyInjection.IServiceCollection.
ServiceEndpointService endpoint that can be contacted.
ServiceProtectionExceptionException thrown when a service protection limit is hit.
SolutionA solution which contains CRM customizations.
SolutionComponentA component of a CRM solution.
SqlCursorContextResultResult of cursor context analysis for SQL IntelliSense.
StringFunctionsT-SQL string functions evaluated client-side.
SystemUserPerson with access to the Microsoft CRM system and who owns objects in the Microsoft CRM database.
TdsCompatibilityCheckerDetermines whether a SQL query can be executed via the Dataverse TDS Endpoint.
TdsQueryExecutorExecutes SQL queries against Dataverse's TDS Endpoint using the SQL Server wire protocol.
TdsScanNodeExecutes a SQL query directly against the Dataverse TDS Endpoint.
ThrottleAwareStrategyAvoids throttled connections and falls back to round-robin among available connections.
ThrottleStateRepresents the throttle state for a connection.
ThrottleTrackerTracks throttle state for connections using a thread-safe concurrent dictionary.
TranspileResultResult of SQL to FetchXML transpilation, including virtual column metadata.
UpdateColumnRequestRequest to update an existing column (attribute) on a Dataverse table.
UpdateGlobalChoiceRequestRequest to update an existing global choice (option set) in Dataverse.
UpdateOptionValueRequestRequest to update an existing option value in an option set.
UpdateRelationshipRequestRequest to update an existing Dataverse relationship.
UpdateStateValueRequestRequest to update a state or status option value label.
UpdateTableRequestRequest to update an existing Dataverse table (entity).
ValidationMessageRepresents a validation message produced during a dry-run or schema authoring operation.
VariableScopeManages SQL variable declarations and values.
VirtualColumnInfoInformation about a virtual column (e.g., "owneridname" that maps to "ownerid").
WebResourceData equivalent to files used in Web development. Web resources provide client-side components that are used to provide custom user interface elements.
WindowDefinitionDefines a single window function to compute within a ClientWindowNode.
WorkflowSet of logical rules that define the steps necessary to automate a specific business process, task, or set of actions to be performed.

Records

TypeSummary
BulkOperationResultResult of a bulk operation.
CompiledOrderByItemA compiled ORDER BY item used by window functions. Contains the column name for
CompiledSetClauseA compiled SET clause for UPDATE statements.
QueryExecutionOptionsPer-query execution options that affect how the query is sent to Dataverse.
SqlCompletionA single completion item for SQL IntelliSense.
SqlDiagnosticA diagnostic message for a region of SQL text (error, warning, or info).
VariableInfoInformation about a declared SQL variable.

Structs

TypeSummary
SourceTokenA token with position and classification for syntax highlighting.

Enums

TypeSummary
AggregateFunctionAggregate functions supported by MergeAggregateNode.
CascadeBehaviorDefines the cascade behavior options for entity relationship actions.
ClientAggregateFunctionAggregate functions supported by ClientAggregateNode.
ConnectionSelectionStrategyStrategy for selecting which connection to use from the pool.
CustomLogicBypassSpecifies which custom business logic to bypass during bulk operations.
DataverseAuthTypeAuthentication type for Dataverse connections.
DmlOperationThe type of DML operation.
OAuthLoginPromptOAuth login prompt behavior.
QueryColumnTypeRepresents the data type of a column in a query result.
SchemaColumnTypeDefines the supported column types for schema authoring operations.
SeedFailureReasonCategorized reasons for seed initialization failure.
SourceTokenTypeLanguage-agnostic source token classification for syntax highlighting.
SqlCompletionContextKindThe kind of completion context at a cursor position in SQL text.
SqlCompletionKindThe kind of completion item in SQL IntelliSense results.
SqlDiagnosticSeveritySeverity level for SQL diagnostics.
TdsCompatibilityResult of a TDS Endpoint compatibility check.
asyncoperation_operationtypeType of the system job.
asyncoperation_statecodeStatus of the system job.
asyncoperation_statuscodeReason for the status of the system job.
componentstateThe state of this component.
componenttypeAll of the possible component types for solutions.
connectionreference_promptingbehaviorThis field configures how this connection reference gets prompted
connectionreference_statecodeStatus of the Connection Reference
connectionreference_statuscodeReason for the status of the Connection Reference
customapi_allowedcustomprocessingsteptypeThe Allowed Custom Processing Step Type
customapi_statecodeStatus of the Custom API
customapi_statuscodeReason for the status of the Custom API
customapifieldtypeCustom API Field Types
customapirequestparameter_statecodeStatus of the Custom API Request Parameter
customapirequestparameter_statuscodeReason for the status of the Custom API Request Parameter
customapiresponseproperty_statecodeStatus of the Custom API Response Property
customapiresponseproperty_statuscodeReason for the status of the Custom API Response Property
environmentvariabledefinition_secretstoreThe secret store where the secret is persisted.
environmentvariabledefinition_statecodeStatus of the Environment Variable Definition
environmentvariabledefinition_statuscodeReason for the status of the Environment Variable Definition
environmentvariablevalue_statecodeStatus of the Environment Variable Value
environmentvariablevalue_statuscodeReason for the status of the Environment Variable Value
isinheritedThe role is inherited
pluginassembly_authtypeAuthentication Type for the Web sources like AzureWebApp, for example 0=BasicAuth
pluginassembly_isolationmodeInformation about how the plugin assembly is to be isolated at execution time; None / Sandboxed / External.
pluginassembly_sourcetypeLocation of the assembly, for example 0=database, 1=on-disk, 2=Normal, 3=AzureWebApp.
pluginpackage_statecodeStatus of the Plugin Package
pluginpackage_statuscodeReason for the status of the Plugin Package
plugintracelog_modeType of Execution
plugintracelog_operationtypeType of Plugin
publisher_address1_addresstypecodeType of address for address 1, such as billing, shipping, or primary address.
publisher_address1_shippingmethodcodeMethod of shipment for address 1.
publisher_address2_addresstypecodeType of address for address 2. such as billing, shipping, or primary address.
publisher_address2_shippingmethodcodeMethod of shipment for address 2.
sdkmessageprocessingstep_invocationsourceIdentifies if a plug-in should be executed from a parent pipeline, a child pipeline, or both.
sdkmessageprocessingstep_modeRun-time mode of execution, for example, synchronous or asynchronous.
sdkmessageprocessingstep_stageStage in the execution pipeline that the SDK message processing step is in.
sdkmessageprocessingstep_statecodeStatus of the SDK message processing step.
sdkmessageprocessingstep_statuscodeReason for the status of the SDK message processing step.
sdkmessageprocessingstep_supporteddeploymentDeployment that the SDK message processing step should be executed on; server, client, or both.
sdkmessageprocessingstepimage_imagetypeType of image requested.
securityrole_isautoassignedValue indicating whether security role is auto-assigned based on user license
serviceendpoint_authtypeAuthentication type for Service Bus
serviceendpoint_connectionmodeConnection mode.
serviceendpoint_contractContract type.
serviceendpoint_messagecharsetCharacter encoding used for messages sent to a service endpoint
serviceendpoint_messageformatFormat type.
serviceendpoint_namespaceformatFormat for Service Bus Namespace
serviceendpoint_schematypeSchema type for Event Grid
serviceendpoint_userclaimUser claim value type.
solution_solutiontypeAll possible types of solution
solutioncomponent_rootcomponentbehaviorIndicates the include behavior of the root component.
systemuser_accessmodeType of user.
systemuser_address1_addresstypecodeType of address for address 1, such as billing, shipping, or primary address.
systemuser_address1_shippingmethodcodeMethod of shipment for address 1.
systemuser_address2_addresstypecodeType of address for address 2, such as billing, shipping, or primary address.
systemuser_address2_shippingmethodcodeMethod of shipment for address 2.
systemuser_azurestateAzure state of user.
systemuser_caltypeLicense type of user. This is used only in the on-premises version of the product. Online licenses are managed through Microsoft 365 Office Portal.
systemuser_deletestateUser delete state.
systemuser_emailrouteraccessapprovalIndicates the approval options for server-side synchronization or Email Router access.
systemuser_incomingemaildeliverymethodIncoming email delivery method for the user.
systemuser_invitestatuscodeUser invitation status.
systemuser_outgoingemaildeliverymethodOutgoing email delivery method for the user.
systemuser_preferredaddresscodePreferred address for the user.
systemuser_preferredemailcodePreferred email address for the user.
systemuser_preferredphonecodePreferred phone number for the user.
systemuser_systemmanagedusertypeThe type of user
workflow_businessprocesstypeBusiness Process Type.
workflow_categoryCategory of the process.
workflow_modeMode of the process.
workflow_modernflowtypeType of the Modern Flow process.
workflow_runasSpecifies the system user account under which a workflow executes
workflow_scopeWorkflow scope.
workflow_stageStage in which the Workflow executes
workflow_statecodeStatus of the workflow
workflow_statuscodeReason for the status of the workflow
workflow_throttlingbehaviortypeType of workflow throttling behavior.
workflow_typeWorkflow type.
workflow_uiflowtypeType of the UI Flow process.