Monthly Archive for June, 2009

Setting up SQL Persistence for WF4 Beta 1

A few customers have hit a speed bump when trying to setup persistence with WF4 Beta1. We have multiple sql scripts included (for 3.5 persistence and 4.0 persistence). The problem is that depending on your WF application model in Beta1 you have to execute different scripts (we’ve fixed this in Beta2).

For WorkflowServiceHost usage, use these SQL scripts:

  • C:\Windows\Microsoft.NET\Framework\v4.0.20408\SQL\en\SqlPersistenceProviderSchema40.sql
  • C:\Windows\Microsoft.NET\Framework\v4.0.20408\SQL\en\SqlPersistenceProviderLogic40.sql

For WorkflowInstance usage, use these SQL scripts (note the lack of “40”):

  • C:\Windows\Microsoft.NET\Framework\v4.0.20408\SQL\en\SqlPersistenceProviderSchema.sql
  • C:\Windows\Microsoft.NET\Framework\v4.0.20408\SQL\en\SqlPersistenceProviderLogic.sql

Also make sure that the connection string in your application matches the database you created.

WF4 Activity Palette

One of the investments we’ve made in WF4 is to increase the number of activities provided by the system. Leon has a nice overview of the activities included in Beta 1 here.

Ramping back up on the technical blog posts

I’ve been pretty quiet recently on the technical blog front, mostly because my work was in the dark depths of development. A few weeks ago, we released Beta 1 of Visual Studio 2010 which includes all of the technologies I’ve been working on for the past 3 years :)

One of the big components included in .Net 4.0 Beta1 is the WF4 framework that I unveiled at PDC. The team is blogging here, and I’ll be including ongoing tidbits for WF and WCF to help smooth out speed bumps encountered by our customers.