SQL Server Compact Workflow Persistence Service

Resource Page Description
This library enabled the use of SQL Server Compact edition as the data store for workflow persistence.

This project uses LINQ to SQL as the data access technology. Although the main point of this project is to use SQL Server Compact edition as the database using LINQ to SLQ means it could equally well be used with a full SQL Server edition. The datbase schema is slightly different to the default Workflow Foundation persistence database used. The main difference is that no provision is made or an owner or an ownedUntill as I consider this less than useful with SQL Server Compact as this is a local in process database and not really meant as a shared database.

Sample usage:

   static void Main(string[] args)
   {
       using(WorkflowRuntime workflowRuntime = new WorkflowRuntime())
       {
           string connectionStr = @"Data Source=WorkflowPersistenceDatabase.sdf";
   
           SqlCeWorkflowPersistenceService persistence = new SqlCeWorkflowPersistenceService(connectionStr, true);
           workflowRuntime.AddService(persistence);
   
           workflowRuntime.WorkflowTerminated += delegate(object sender, WorkflowTerminatedEventArgs e)
           {
               Console.WriteLine(e.Exception.Message);
           };
   
           WorkflowInstance instance = workflowRuntime.CreateWorkflow(typeof(TestClient.Workflow1));
           instance.Start();
   
           Console.WriteLine("Done...");
           Console.ReadLine();
       }
   }