SQL Workflow Instance Store
The .NET Framework 4.6.1 ships with the SQL Workflow Instance Store, which allows workflows to persist state information about workflow instances in a SQL Server 2005 or SQL Server 2008 database. This feature is primarily implemented in the form of the SqlWorkflowInstanceStore class, which derives from the abstract InstanceStore class of the persistence framework. The SQL Workflow Instance Store feature constitutes a SQL persistence provider, which is a concrete implementation of the persistence API that a host uses to send persistence commands to the store.
The SQL Workflow Instance Store supports both self-hosted workflows or workflow services that use WorkflowApplication or WorkflowServiceHost as well as services hosted in WAS using WorkflowServiceHost. You can configure the SQL Workflow Instance Store feature for self-hosted services programmatically by using the object model exposed by the feature. You can configure this feature for services hosted by WorkflowServiceHost both programmatically by using the object model and also by using an XML configuration file.
The SQL Workflow Instance Store feature (SqlWorkflowInstanceStore class) does not implement PersistenceProviderFactory and hence does not offer persistence support for durable non-workflow WCF services. It also does not implement WorkflowPersistenceService and hence does not offer persistence support for 3.x workflows. The feature supports persistence for only WF 4.0 (and later) workflows and workflow services. The feature also does not support any databases other than SQL Server 2005 and SQL Server 2008.
The topics in this section describe properties and features of the SQL Workflow Instance Store and provide you with details on configuring the store.
Windows Server App Fabric provides its own instance store and tooling to simplify the configuration and use of the instance store. For more information, see see Windows Server App Fabric Instance Store. For more information about the App Fabric SQL Server Persistence Database see App Fabric SQL Server Persistence Database