First, I'm new to Workflow Foundation so my knowledge of it is pretty limited. However I'm interested in using workflow for my next project for two reasons:
1. it's going to be a long-running task
2. it should be understandable by non-dotnet developpers
3. WF looks cool :p
But my main concern for now is the compatibility of WF with Oracle databases. We do have SQLServer too, so we could use it for workflow persistence. However all of our business data is in an Oracle database.
I've read that I can use the TransactionScope object to run my activities within the same Transaction. First, are we talking DB Transaction ? And is the following scenario going to work :
I have a TransactionScope object which contains several activities. These activities should make various CRUD operations. Note that the DB calls are not actually made by the activities but by my Data Access Layer, which is in a separate project.
If one of the DB calls fails, is the TransactionScope object going to rollback the various CRUD operations done by my activities ?
Thanks for helping.
View Complete Post