Allow to disable auto-transactions for stored procedures mapped to CUD operations #28511
Description
Some sprocs cannot be executed in a transaction. These need a configuration flag that will affect SaveChanges and the execution strategy.
Current workaround is to use a transaction interceptor.
Split off from #245