Workflow Service Promoted Properties

[venkatesh]

Is there any documentation / sample available for Promoted properties in workflow service using Devart . I have successfully implemented instance persitence and tracking .

[Shalex]

Is there any documentation / sample available for Promoted properties in workflow service using Devart

We are working on the sample. As soon as it is ready, we will send it to you.

[andreash]

Is the material available online?

[Shalex]

@andreash
We have just resent a test project (sent previously to venkatesh) to your forum profile email.

Here is a description of the corresponding sample for System.Data.SqlClient: http://msdn.microsoft.com/en-us/library ... .110).aspx. An attached sample is a modified (for using it via Devart.Data.Oracle) standard project:

1) create WF4.5 schema in your database by running the scripts:
C:\Program Files (x86)\Devart\dotConnect\Oracle\WF Services\NET45\OracleInstanceStoreSchema45.sql
C:\Program Files (x86)\Devart\dotConnect\Oracle\WF Services\NET45\OracleInstanceStoreLogic45.sql

2) open \PropertyPromotionActivity\CS\PropertyPromotionActivity.sln, update connection string in CounterServiceApplication\App.config and absolute path specified in the sad:XamlDebuggerXmlReader.FileName attribute in CounterServiceApplication\CounterService.xamlx . Also update references to
C:\Program Files (x86)\Devart\dotConnect\Oracle\Devart.Data.dll
C:\Program Files (x86)\Devart\dotConnect\Oracle\Devart.Data.Oracle.dll
C:\Program Files (x86)\Devart\dotConnect\Oracle\WF Services\NET45\Devart.Data.Oracle.WorkflowFoundation.dll

Now sample is ready to run.

Note: the [dbo].[CounterService] view is used in the System.Data.SqlClient sample for monitoring a work of WF code. Oracle doesn't allow to create a similar view so we provide a small additional project \PropertyPromotionActivity\GetPromotedProperties\GetPromotedProperties.sln which talks to the InstancePromotedProperties table and returns its latest row.