How to use SharedConnectionWorkflowTransactionService?  
Author Message
Chris Jiang





PostPosted: Windows Workflow Foundation, How to use SharedConnectionWorkflowTransactionService? Top

The translation what i found in SDK is that SharedConnectionWorkflowTransactionService connect to the same DB using multiple services, for example:SqlWorkflowPersistenceService and SqlTrackingService use the same DB,and it can share data connection and transaction between two services.
But in forum someone says that it also be used when host and DB in the same machine.
Now, the thing I meet is that SqlWorkflowPersistenceService and SqlTrackingService use different DB, DB and host do not in a same machine,need i use SharedConnectionWorkflowTransactionService
If needed,how to initialize using connectionString


Software Development for Windows Vista18  
 
 
Steve Danielson





PostPosted: Windows Workflow Foundation, How to use SharedConnectionWorkflowTransactionService? Top

Hi Chris,

SharedConnectionWorkflowTransactionService is replaced with SharedConnectionWorkflowCommitWorkBatchService in Beta 2.2. It can be used if you have Persistence and Tracking services that use the *exact* same connection string and you want them to participate together in transactions. If you are using a different DB for Persistence and Tracking then the connection strings would not be an exact match and it is not appropriate (or possible) to use this.

Thanks,

Steve Danielson [Microsoft]
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm


 
 
Joel West





PostPosted: Windows Workflow Foundation, How to use SharedConnectionWorkflowTransactionService? Top

I'll add some to this. The SharedConnectionWorkflowCommitWorkBatchService can only be used with the out of box SqlWorkflowPersistenceService and SqlTrackingService. The connection strings must be the same (both sets of Sql objects in the same databases). This is intended as a performance enhancement that avoids the overhead of extra connections to the database and DTC transactions.

Important: The SharedConnectionWorkflowCommitWorkBatchService is not about whether or not persistence and tracking will be written transactionally. Regardless of the WorkflowCommitWorkBatchService that you use the services will always use the same transaction (assuming the SqlTrackingService is left in its default IsTransactional=true state; setting this to false will have a completely different write semantic however, see the help docs for more details).

Thanks,

Joel West

MSFTE - SDE in WF runtime and hosting

This posting is provided "AS IS" with no warranties, and confers no rights


 
 
Osi





PostPosted: Windows Workflow Foundation, How to use SharedConnectionWorkflowTransactionService? Top

Hi Joel,

you say: "see the help docs for more details" - which help docs do you mean

Thanks
Osi


 
 
Joel West





PostPosted: Windows Workflow Foundation, How to use SharedConnectionWorkflowTransactionService? Top

I was just thinking of the SqlTrackingService section of the docs that details the different settings. Probably want to get the June CTP that was just released to get the latest available docs.

Thanks,

Joel West

MS SDE in WF runtime and hosting

This posting is provided "AS IS" with no warranties, and confers no rights