How to flush out suspended WCF workflows from the instancestore?

We have identified the need to flush out several different workflows that have been suspended/persisted for a long time (i.e. hung instances). This is so that our test environment can be flushed clean before acceptance tests are re-run.

The dirty solut开发者_运维问答ion is to use a sql script to remove records from the InstancesTable and other related tables in the database.

What's the proper solution?

These are WCF workflows.

Test rig is running XP.

Using the AppFabric you can use the UI, or I asume PowerShell commands, to delete individual instanced. For development and test purposes I normally just recreate the database by running SqlWorkflowInstanceStoreSchema.sql script again.

Found a way to do it (thanks to Pablo Rotondo on MSDN):

http://www.funkymule.com/post/2010/04/28/how-to-resume-suspended-workflows-in-net-40.aspx