Data persistence and retrieving the data from the persistence store using WF 4.5

See more:

WF

I found a similar question at

Persistence and Tracking in WF 4.5
http://www.codeproject.com/Questions/593169/PersistenceplusinplusWFplus-c

, but did not find an answer. That's why I am reposting my question.

I am using .Net Framework 4.5, WF 4.5, SQL Server 2014 and MVC Web App.

I have a Flow Chart Workflow (WF 4.5)which invokes business class mothods in a sequence. After executing each method, FlowDecision is used to either continue or stop.
The workflow also have a ForEach loop in which a file is processed. If the method returns a failure, I need to persist the data that failed and continue with the next file.
Also, if there is a network/ database error that stops the workflow before it's completion, I need to persist data and workflow step where it stoped.

User will monitor the workflow erros using MVC web app and after fixing the errors, user should be able to restart the workflow where it is stopped or process the files that were failed.

How do I do this. I have created the Persistence Instance store by executing SqlWorkflowInstanceStoreLogic, SqlWorkflowInstanceStoreSchema and SqlWorkflowInstanceStoreSchemaUpgrade scripts from .Net Framework installation folder.

Somebody, please post some sample code to persist, track and resume workflow using WF 4.5.

Thanks in advance.

What I have tried:

Looked into Persistence and Tracking in WF 4.5
http://www.codeproject.com/Questions/593169/PersistenceplusinplusWFplus-c

But I did not find a solution posted for this query.