Microsoft Windows Workflow Foundation 4.0 Cookbook

Configuring the SQL persistence store

In real-world applications, to make sure the performance meets requirements, it is recommended to use a database as the workflow persistence store. WF4 has a built-in SQL persistence store type. All we need to do is some configurations.

Getting ready

SQL Server (include express edition) 2005/2008 is needed to perform this task.

How to do it...

1. Create a workflow project:

   Create a new Workflow Console Application under solution Chapter06 and name the project as ConfiguringSqlPersistenceStore.

2. Set up a persistence database:

   We can find SQL scripts in %WINDIR%\Microsoft.NET\Framework\v4.xxx\SQL\EN. In this folder, only two files are needed: SqlWorkflowInstanceStoreSchema.sql and SqlWorkflowInstanceStoreLogic.sql ...