SQL persistence service

Question

I am trying to run the code sample from Workflow Foundation which uses persistence service's functionality. In the code I've observed:

Initial Catalog=SqlPersistenceService;Data Source=localhost;Integrated Security=SSPI;

When I run the code I am getting an exception. How do I enable persistence services on my SQLEXPRESS server?

Answer 1

See %WINDIR%\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\EN. These are the scripts that enable SqlWorkflowPersistenceService.

You'll need SqlPersistenceService_Schema.sql and SqlPersistenceService_Logic.sql. First one defines the structure of database and tables and second one defines stored procedures.