Search code examples
nservicebussqlconnectionsqlcommand

NServicebus handler with custom sqlconnection

I have an NServiceBus handler that creates a new sql connection and new sql command.

However, the command that is executed is not being committed to the database until after the whole process is finished.

It's like there is a hidden sql transaction in the handler itself.

I moved my code into a custom console application without nservicebus and the sql command executed and saved immediately. Unlike in nservicebus where it doesn't save until the end of the handler.

Solution

  • Found the solution.

    In my connection string I had to add Enlist=False