Execute Reader error in a Workflow project
I am developing a workflow project whose Configurable Auto Start component reads a database to determine if there is any work to process. Following the Configurable Auto Start I execute the same query again to pull the Ids of the records to be processed. For each of the record Ids I execute a component that uses the ORMQueue to create a Request object which is then processed.
I am having intermittent problems where I get an error dealing with the DataReader. The messages are
ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.
There is already an open DataReader associated with this Command which must be closed first
Are there components I can utilize to resolve these errors when they are thrown?