SQL Persistence in Workflow

Question

Hi What is SQL Persistence in Workflow?

Hemant Kumar · Answer

Normally the workflow is persisted when it becomes idle. How soon it gets persisted also depends upon factors such as the polling interval ( which you would have provided while creating the SQLPersistenceService and attaching it to the runtime.) Also Everything that the workflow uses esp. The ExternalDataEvent args and the events should be marked as Serializable . Regarding handling Exceptions you should add FaultHandlersActivity to your workflow and the exception that is caught will be saved in the Fault property that gets exposed along with the FaultHandlersActivity. http://msdn.microsoft.com/en-us/library/system.workflow.runtime.hosting.sqlworkflowpersistenceservice.aspx Hope that's helpful.