

Set interval to check for runnable instances to 2 seconds. Set interval to renew instance lock to 5 seconds. Define SqlWorkflowInstanceStoreBehavior: Using this class and a few lines is possible to store workflow instances in SQL Server as shown, To this end Microsoft workflow team implemented the SqlWokflowInstanceStore class.

In version 11.1.7 our team now provides workflow instance support outside XAF borders! With a few lines of code, it is now possible to store our workflows in any of the 14 database systems described.ĭurability is a key benefit of the Workflow Foundation and it is based on the ability to store a running workflow instance on the fly at almost any time.
#XAF DEVEXPRESS CODE#
For more info consult our docs, blogs, code central and support center. XAF provides a comprehensive set of solutions that allow you to outsource all of the mundane programming tasks leaving you to focus purely on your business needs. This is only one example of what XAF can do for us. More info Database Systems Supported by XPO Finally since XAF uses XPO to access data we can easily support 16 different database systems simply by providing a connection string!į 2.5.1.0 XAF also gives us increased control over our workflows for example through the ability to manually start workflows. In order to start modeling workflows we can use VS design time along with our re-hosted runtime Workflow designer and custom WF4 activities. It provides a ready made solution for creating and deploying a server that will execute workflows as described here.

XAF is the perfect workflow modeling environment. Luckily XAF provides us with an easier route! Surprisingly there is no such solution out there! Moreover there is very little useful code or samples available. Usually when dealing with these issues the first thing we do is to carry out a Google search for storage solutions. In addition our customers may follow different standards (Oracle, Firebird, VistaDB, MySQL, PostgreSQL etc.) and it’s unrealistic to hire more people to support SQL Server infrastructure. However its implementation is based on stored procedures which can be a bit scary if you are not familiar with them. NET Framework 4 ships with the SQL Workflow Instance Store which allows workflows to persist state information about workflow instances in a SQL Server 2005 or SQL Server 2008 database.
