ice to have - Configuration settings

Topics: Developer Forum
Mar 1, 2007 at 10:47 PM

Not sure if this belong in the work flow threads or page flow threads:

Under the page flow custom section within the config file there are work flow service settings.
For example,
<pageFlowProvider providerType="Microsoft.Practices.PageFlow.WorkflowFoundation.WorkflowFoundationPageFlowProvider, Microsoft.Practices.PageFlow.WorkflowFoundation"/>
<hostingWorkflowRuntime Name="Hosting">
<add type="System.Workflow.Runtime.Hosting.SqlWorkflowPersistenceService, System.Workflow.Runtime, Version=3.0.00000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionString="The actual Connection String details" LoadIntervalSeconds="5" UnloadOnIdle="true"/>
<add type="System.Workflow.Runtime.Hosting.ManualWorkflowSchedulerService, System.Workflow.Runtime, Version=3.0.00000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" useActiveTimers="true"/>
<add type="System.Workflow.Activities.ExternalDataExchangeService, System.Workflow.Activities, Version=3.0.00000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<pageFlowInstanceStoreProvider providerType="Microsoft.Practices.PageFlow.Storage.EnterpriseLibrary.PageFlowInstanceCorrelationSqlProvider, Microsoft.Practices.PageFlow.Storage.EnterpriseLibrary" connectionString="Connection Name that references connection String Section"/>
<pageFlowInstanceCorrelationTokenProvider providerType="Microsoft.Practices.PageFlow.Storage.EnterpriseLibrary.CookiePageFlowCorrelationTokenProvider, Microsoft.Practices.PageFlow.Storage.EnterpriseLibrary"/>

The page flow instance provider allows you to just put in the 'connection name' which is used to references the connection string via connection string section. However, under the hosting work flow run time when adding a sql work flow persistence service you can NOT just set a connection name, but need to put the actual connection string within it. It would be nice to just to put in a connection name so that all connection string within the configuration file are centralized within the connection string section.

• A work around is to code a custom persistence service that handles the logic to reference from the connection strings section, but that seems over kill.

Sonny M
Mar 12, 2007 at 6:42 AM
You are right. And at this moment the only way to fix this is what you stated and that is to create a custom persistence service that handles the logic.