O'Reilly logo

Microsoft Windows Workflow Foundation 4.0 Cookbook by Andrew Zhu

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required