Devart Forums

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

venkatesh wrote: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.

Is the material available online?

@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.