How to: Configure Persistence with WorkflowServiceHost

This topic applies to Windows Workflow Foundation 4 (WF4).

This topic describes how to configure the SQL Workflow Instance Store feature to enable persistence for workflows hosted in WorkflowServiceHost by using a configuration file. Before using the SQL Workflow Instance Store feature you must create a SQL database that is used to persist workflow instances. For more information, seeHow to: Enable SQL Persistence for Workflows and Workflow Services.

To Configure the SQL Workflow Instance Store in Configuration

1. The properties of the SQL workflow instance store can be configured through the SqlWorkflowInstanceStoreBehavior, a service behavior that allows you to change the settings through XML configuration. The following configuration example shows how to configure the SQL workflow instance store by using the <sqlWorkflowInstanceStore> behavior element in a configuration file.

   <serviceBehaviors>
       <behavior name="">
           <sqlWorkflowInstanceStore 
                connectionString="provider=System.Data.SqlClient;Data Source=(local);Initial Catalog=DefaultPersistenceProviderDb;Integrated Security=True;Async=true"
                instanceEncodingOption="GZip | None"
                instanceCompletionAction="DeleteAll | DeleteNothing"
                instanceLockedExceptionAction="NoRetry | SimpleRetry | AggressiveRetry"
                hostLockRenewalPeriod="00:00:30" 
                runnableInstancesDetectionPeriod="00:00:05">
           <sqlWorkflowInstanceStore/>
       </behavior>
   </serviceBehaviors>
   

   For more information about how to configure the SQL workflow instance store, see How to: Enable SQL Persistence for Workflows and Workflow Services. For more information about the individual settings for the <sqlWorkflowInstanceStore> behavior element, see SQL Workflow Instance Store. Windows Server App Fabric provides its own persistence store. For more information, see Windows Server App Fabric Persistence.

   Note

   The preceding configuration example uses simplified configuration. For more information, see Simplified Configuration

To Configure the SQL Workflow Instance Store in Code

1. The properties of the SQL workflow instance store can be configured through the SqlWorkflowInstanceStoreBehavior, a service behavior that allows you to change the settings through code. The following example shows how to configure the SQL workflow instance store by using the SqlWorkflowInstanceStoreBehavior behavior element in a code

   host.Description.Behaviors.Add(new SqlWorkflowInstanceStoreBehavior
   {
      ConnectionString = "provider=System.Data.SqlClient;Data Source=(local);Initial Catalog=DefaultPersistenceProviderDb;Integrated Security=True;Async=true",
      InstanceEncodingOption = "GZip | None",
      InstanceCompletionAction = "DeleteAll | DeleteNothing",
      InstanceLockedExceptionAction = "NoRetry | SimpleRetry | AggressiveRetry",
      HostLockRenewalPeriod = new TimeSpan(00, 00, 30),
      RunnableInstancesDetectionPeriod = new TimeSpan(00, 00, 05)
   });
   

   For more information about how to configure the SQL workflow instance store, see How to: Enable SQL Persistence for Workflows and Workflow Services. For more information about the individual settings for the SqlWorkflowInstanceStoreBehavior behavior element, see SQL Workflow Instance Store. Windows Server App Fabric provides its own persistence store. For more information, see Windows Server App Fabric Persistence.

   Note

   The preceding configuration example uses simplified configuration. For more information, see Simplified Configuration

   For an example of how to configure persistence programmatically see How to: Enable Persistence for Workflows and Workflow Services.

See Also

Concepts

Workflow Persistence

Other Resources

Workflow Services
Windows Server App Fabric Persistence