Book Image

Microsoft Windows Workflow Foundation 4.0 Cookbook

By : Andrew Zhu
Book Image

Microsoft Windows Workflow Foundation 4.0 Cookbook

By: Andrew Zhu

Overview of this book

Windows Workflow Foundation 4.0 (WF) is a significant part of .NET Framework 4.0. WF makes workflow technology available to every single programmer that uses the .NET Framework 4.0. It is easy to create long running and distributed programs using WF with the right knowledge. With this book, you will discover that working with workflows is easy. This book provides both step-by-step recipes and relevant background information. It covers all the important aspects of Windows Workflow Foundation 4.0. The best thing about this book is that all recipes are based on real-world experiences of Andrew Zhu. Andrew is a global WF and BizTalk technology support engineer for Microsoft. This book covers everything you need to know, when working with workflows. Get to grips with flow control activities, messaging, and transaction processes with easy to understand steps followed by explanations. You will quickly learn to use collection and custom WF activities and WF services.You will see recipes that illustrate integration of Windows Workflow with other applications such as WPF, ASP.NET, WCF service.Lastly, you will discover how easily you can customize W4 Designer with WF rule engine and others.
Table of Contents (15 chapters)
Microsoft Windows Workflow Foundation 4.0 Cookbook
Credits
About the Author
About the Reviewers
Foreword
Preface
Index

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.

    We first execute SqlWorkflowInstanceStoreSchema.sql and 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....