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
Chapter06and name the project as
We first execute
SqlWorkflowInstanceStoreSchema.sqland then execute
SqlWorkflowInstanceStoreLogic.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....