troubleshooting Question

How do i get the ConnectionString from commonParameters?

Avatar of thomas_eg
thomas_eg asked on
2 Comments1 Solution475 ViewsLast Modified:
Im using windows workflow and SqlTrackingService in an Wcf application running on IIS.

How do i get the ConnectionString from commonParameters in my web.config?
I am asking because, SqlTrackingQuery require a connectionstring, and i only want to have a single connectionstring in the config.

My web.config look something like this:
<?xml version="1.0" encoding="utf-8" ?>
      <service name="TestService.Service" behaviorConfiguration="ServiceBehavior">
        <endpoint address="" binding="basicHttpBinding" contract="TestService.IService" />
        <behavior name="ServiceBehavior">
          <serviceMetadata httpGetEnabled="true"/>
          <serviceDebug includeExceptionDetailInFaults="true"/>
          <workflowRuntime name="WorkflowServiceHostRuntime" validateOnCreate="true" enablePerformanceCounters="true">
              <add name="ConnectionString" value="Data Source=localhost\SQLEXpress;Initial Catalog=TrackingAndPersistence;Integrated Security=True"/>
              <add type="System.Workflow.Runtime.Hosting.SqlWorkflowPersistenceService, System.Workflow.Runtime, Version=3.0.00000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" LoadIntervalSeconds="1" UnLoadOnIdle="true" />
              <add type="System.Workflow.Runtime.Tracking.SqlTrackingService, System.Workflow.Runtime, Version=3.0.00000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
              <add type="System.Workflow.Runtime.Hosting.SharedConnectionWorkflowCommitWorkBatchService, System.Workflow.Runtime, Version=3.0.00000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    <compilation debug="true">
        <add assembly="System.WorkflowServices, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros