Workflow Service Promoted Properties

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
venkatesh
Posts: 2
Joined: Wed 17 Jul 2013 02:54

Workflow Service Promoted Properties

Post by venkatesh » Thu 21 Nov 2013 06:10

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

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Workflow Service Promoted Properties

Post by Shalex » Fri 29 Nov 2013 17:42

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.

andreash
Posts: 4
Joined: Fri 11 Dec 2015 10:25

Re: Workflow Service Promoted Properties

Post by andreash » Mon 18 Jan 2016 12:17

Is the material available online?

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Workflow Service Promoted Properties

Post by Shalex » Wed 20 Jan 2016 18:17

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

Post Reply