Chapter 6 Quick Reference

To

Do This

Create the workflow persistence database

After creating a new database for the task, execute within SQL Server Management Studio Express the SQL scripts you find in the <%WINDIR%>\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\EN directory within SQL Server Management Studio. You’ll need to execute both the SqlWorkflowPersistenceService_Schema.sql script and the SqlWorkflowPersistenceService_Logic.sql script.

Use the SqlWorkflowPersistenceService

After creating an instance of WorkflowRuntime but before you call its StartRuntime method, add a new instance of SqlWorkflowPersistenceService to the runtime services using WorkflowRuntime.AddService.

Manually unload and persist a workflow instance

Call WorkflowInstance.Unload ...

Get Microsoft® Windows® Workflow Foundation Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.