Can WF4 promoted properties be queried directly through the InstanceStore?

Question

Further to my previous question Resuming a persisted Window Workflow 4 Activity without knowing concrete type of activity

Is there a way of querying promoted properties directly through the InstanceStore (in my case a SqlWorkflowInstanceStore instance), given a workflowId?

I can query the database directly with SQL, but wondered if this could be done directly through the instance store which I already use in my code. I've been looking at the SqlWorkflowInstanceStore.Execute method and the QueryActivatableWorkflowsCommand but can't see that these do quite what I want.

Is this possible, and if so how?

Answer 1

You have to use SQL commands to query promoted properties.