Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

about the sqlserver #69

Closed
hellozhang opened this issue Nov 7, 2017 · 3 comments
Closed

about the sqlserver #69

hellozhang opened this issue Nov 7, 2017 · 3 comments

Comments

@hellozhang
Copy link

  services.AddWorkflow(x => x.UseSqlServer(@"Server = 117.169.87.18;Database = workflow;User ID = sa;Password = jlkj207.;Trusted_Connection = False;", true, true));

can you show me , where the sql database structure file. how can it work ? and the data will record the every step ? maybe you can give a full example

@hellozhang
Copy link
Author

waiting your anwser

@qazq
Copy link

qazq commented Nov 10, 2017

Please refer to WorkflowInstance.cs. The List<ExecutionPointer> ExecutionPointers record all the steps of this workflow.

To get WorkflowInstance please refer to WorkflowsController.cs and see _workflowStore.GetWorkflowInstances(), _workflowStore.GetWorkflowInstance()

@danielgerlag
Copy link
Owner

@hellozhang this persistence provider uses entity framework core migrations

https://docs.microsoft.com/en-us/ef/core/miscellaneous/cli/dotnet

You can use the dotnet ef migrations script CLI command to generate a SQL script with the schema or the Script-Migration command from the package manager console in Visual Studio.

You can use the repository methods as shown by @qazq in the comment above to access it programatically, regardless of which persistence provider you choose to use.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants