I'm trying to debug a workflow project that's using the default WF SQL persistence schema. Does anyone know of a good explanation for what the data in each table represents?
Sql – Windows Workflow Foundation persistence schema explanation
netsqlworkflowworkflow-foundation
Related Topic
- C# – Proper use of the IDisposable interface
- Sql – When should I use CROSS APPLY over INNER JOIN
- Sql – How to do an UPDATE statement with JOIN in SQL Server
- Sql – How to escape a single quote in SQL Server
- C# – How to remedy “The breakpoint will not currently be hit. No symbols have been loaded for this document.” warning
- Sql – What are the options for storing hierarchical data in a relational database
- Scala: list.flatten: no implicit argument matching parameter type (Any) = > Iterable[Any] was found
Best Answer
The only two tables in the persistence schema are the InstanceState and CompletedScope tables. The InstanceState table stores the where/when/who of what is happening with the workflow at the point it was unloaded. The CompletedScope table stores completed workflows that are compensatable I believe.
If you want to know more about the tracking tables as well, here's a good link:
http://msdn.microsoft.com/en-us/library/aa347864.aspx