Example of how InterpolatedSql will work if IDbConnection has Transaction?

Question

Example of how InterpolatedSql will work if IDbConnection has Transaction?

Closed this issue 9 months ago · 5 comments

Answer 1 · 2024-04-17T02:59:05.000Z

Hi there, sorry I have encountered an error saying BeginExecuteReader 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

When my DbConnection goes BeginTransaction(), and it seems not like it :(. Any idea what its complaining?

thanks :)

Answer 2 · 2024-04-17T03:19:46.000Z

Please share a small example where the problem can be reproduced.

Answer 3 · 2024-04-17T04:30:36.000Z

I have somehow resolved the issue. The resolution was to pass in the transaction parameter.. But here is a small example where its reproduced. It seems like we have to pass in transaction if the connection has an active transaction. Please confirm if this is the correct behaviour :) thanks!

Answer 4 · 2024-04-17T11:07:10.000Z

Yep, passing the transaction to the extension methods (preferably using named parameter to avoid calling the wrong overload) seems to be the correct way of using transactions in Dapper.
DapperLib/Dapper#713

Answer 5 · 2024-04-17T11:10:02.000Z

thanks for the link and the help! :)