https://naiwaen.debuggingsoft.com/2022/06/c-dapper-error-connection-assigned-to-the-command-is-in-a-pending-local-transaction/