Persistence questions

First-

I'm just coming back to adding persistence since the beta 1 version of my WF. I find some params that are not documented clearly:

WorkflowPersistenceService persistenceService =newSqlWorkflowPersistenceService("Initial Catalog=SqlPersistenceService;Data Source=localhost;Integrated Security=SSPI;",true,newTimeSpan(1, 0, 0),newTimeSpan(0, 0, 10));

The last param "loadingInterval" - does it mean that the wf will be persisted when it has been Idle this long? or something else? I'd like to only persist when my wf has been idle for 10 seconds, since it can take 5 seconds for an external activity to finish up, and I don't want to persist out in that case.

Second -

Where can I get example sql scripts to set up the db for persistence? I don't find them in the July CTP.

Thanks!

Riley

[1524 byte] By [rileyt] at [2007-12-24]
# 1

The OOB SqlPersistence service doesn't have any concept of idle after 10 seconds. You'd have to build your own to get this kind of functionality. the scripts are in c:\windows\microsoft.net\framework\v3.0\window workflow foundation\sql\en (or your language).

The loadinginterval relates to delay or other timer based activities. Since the workflow persists - the timer is turned off in the workflowruntime and persisted with the workflow. The persistence service is responsible for "waking" it up and starting the workflow again after the in-memory time-out would have hit. So this interval should be set to be smaller than your smallest delay activity timeoutduration.

JonFlanders at 2007-8-31 > top of Msdn Tech,Software Development for Windows Vista,Windows Workflow Foundation...

Software Development for Windows Vista

Site Classified