Can you execute the `ExecuteNonQueryAsync` in a transaction when it is provided by the database?

[paillave]

Can you execute the ExecuteNonQueryAsync in a transaction when it is provided by the database?

Reason

I try to execute the Delete(EFCore) operator within a transaction scope, but it throws an error, due to this command. Setting its Transaction property based on the Database should fix this.

https://github.com/paillave/Etl.Net/blob/698582b6b9124d823b98ac0ec2340f395dbeaac8/src/Paillave.EntityFrameworkCoreExtension/Core/EfExtensions.cs#L61

Originally posted by @TomatorCZ in https://github.com/paillave/Etl.Net/issues/292#issuecomment-1108593923

[paillave]

Sorry for the delayed answer, I must spend time to deal with proper transaction handling within the whole system, as I feel this kind of considerations might hide some underlying problems. Once it is done I will communicate on this.