IWorkflowTypeEventHandler thrown from OrchardCore.Workflows.Http.Handlers.WorkflowTypeRoutesHandler by InvalidOperationException System.InvalidOperationException: The connection does not support MultipleActiveResultSets.

[weirdyang]

repo:OrchardCMS/OrchardCore 19:11:25.0140|Default|00-c13fd692943fc1afb8be5e87b59f96c0-f139fa52a77c0b39-00||OrchardCore.Workflows.Services.WorkflowTypeStore|ERROR|IWorkflowTypeEventHandler thrown from OrchardCore.Workflows.Http.Handlers.WorkflowTypeRoutesHandler by InvalidOperationException System.InvalidOperationException: The connection does not support MultipleActiveResultSets.

May I know why this operation requires multiple active result sets?

[Piedone]

It shouldn't. Previously we had some coding mistakes that sporadically resulted in such errors, but that shouldn't be the case (at least with 2.1.x). This error is raised when two threads use the same ISession, i.e. you have multi-threaded code (executing withing the same request) and an ISession instance is shared among them.

You can set EnableThreadSafetyChecks to make YesSql throw an explicit exception when this happens, with details about the two threads, see https://docs.orchardcore.net/en/latest/reference/modules/Data/#configuring-yessql.