locked
WCF Workflow Service and Pesistence RRS feed

  • Question

  • Hi Community:

    I see no specific documentation on how to configure a WCF WF4 service to use the SQL instance store. I have created a WF4 WCF workflow and am using no custom activities.   The service gets created from a call by a console workflow application.

    I have created the instance store database and stored procs by running the MS scripts.  I don't see anywhere in my receive activity where there  are properties to configure persistence.

    So, simply how is a WCF workflow, that gets created through a service call, configured for sql persistence?

    Friday, March 4, 2011 2:54 PM

Answers

  • We typically recommend that you host WorkflowServices in IIS with Windows Server AppFabric - this will automatically setup the instance store for you.

    For more information see

    How to: Enable SQL Persistence for Workflows and Workflow Services

     http://msdn.microsoft.com/en-US/library/ee395773.aspx

     


    Sr. Program Manager, AppFabric Development Platform (WF/WCF) http://blogs.msdn.com/rjacobs http://www.twitter.com/ronljacobs
    • Proposed as answer by Andrew_Zhu Tuesday, March 8, 2011 3:40 AM
    • Marked as answer by SteveK-MS Tuesday, March 8, 2011 11:20 AM
    Friday, March 4, 2011 4:29 PM

All replies

  • We typically recommend that you host WorkflowServices in IIS with Windows Server AppFabric - this will automatically setup the instance store for you.

    For more information see

    How to: Enable SQL Persistence for Workflows and Workflow Services

     http://msdn.microsoft.com/en-US/library/ee395773.aspx

     


    Sr. Program Manager, AppFabric Development Platform (WF/WCF) http://blogs.msdn.com/rjacobs http://www.twitter.com/ronljacobs
    • Proposed as answer by Andrew_Zhu Tuesday, March 8, 2011 3:40 AM
    • Marked as answer by SteveK-MS Tuesday, March 8, 2011 11:20 AM
    Friday, March 4, 2011 4:29 PM
  • Thanks Ron:

    When I configured the Service Behavior correcly in my WFC WF's web.config, the workflow was be stored in the SQL instance store.

    Another part I was getting hung up on was whether or not to initialize a correlation or to simply "correlateOn".  Because I am launching the workflow on the receive message, it seems I only need to "CorrelateOn" with future WCF messages.

     

    Steve

    Tuesday, March 8, 2011 11:20 AM