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.
Create a new Workflow Console Application under solution
Chapter06
and name the project asConfiguringSqlPersistenceStore
.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
andSqlWorkflowInstanceStoreLogic.sql
.We first execute
SqlWorkflowInstanceStoreSchema.sql
and then executeSqlWorkflowInstanceStoreLogic.sql
. We can execute these SQL files in Visual Studio or SQL Server Management Studio. I would prefer to write a batch file to do all these steps....