Solved

Persistence IN WCF Workflow Service 4.0

Posted on 2011-09-27
1
884 Views
Last Modified: 2012-05-12
I have created a WCF Workflow service in .NET 4.0.. How to implement persistence in it?

I have added following in web.config:

 <add name ="ConnStringPersistence" connectionString="Data Source=(local);Integrated Security=SSPI;Initial Catalog=SqlWorkflowInstanceStore;" providerName="System.Data.SqlClient"/>

<system.serviceModel>
    <behaviors>
      <serviceBehaviors>
        <behavior>

          <!-- To avoid disclosing metadata information, set the value below to false and remove the metadata endpoint above before deployment -->
          <serviceMetadata httpGetEnabled="true"/>

          <!-- To receive exception details in faults for debugging purposes, set the value below to true.  Set to false before deployment to avoid disclosing exception information -->
          <serviceDebug includeExceptionDetailInFaults="true"/>
          <sqlWorkflowInstanceStore connectionStringName="ConnStringPersistence"/>
          <workflowIdle timeToUnload="0"/>
        </behavior>

      </serviceBehaviors>
    </behaviors>
    <serviceHostingEnvironment multipleSiteBindingsEnabled="true" />
  </system.serviceModel>


When I add persist activity from toolbox, I get an entry in table  "InstancesTable" with exception "Persist activities cannot be contained within no persistence blocks."

How to solve it?
0
Comment
Question by:priyanka_kothari
1 Comment
 
LVL 25

Accepted Solution

by:
apeter earned 500 total points
Comment Utility
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In previous Articles, we have discussed how we can upload a file using .asmx web service and isolated storage space. Here, in continuation to the topic, I am going to discuss how we can use WCF for the same purpose. Steps: 1.Create the silverli…
While working on Silverlight and WCF application, I faced one issue where fault exception occurred at WCF operation contract is not getting propagated to Silverlight client. So after searching net I came to know that it was behavior by default for s…
This video discusses moving either the default database or any database to a new volume.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now