I use Adapter v4.2 and 5.5
I override method CreateRecoveryStrategyToUse in DataAdapter to use recovery strategy automatically.
But now I have query where I do not want to use recovery strategy and I cannot find an easy way how to temporary disable "global" strategy for particular query.
The only way I found is to instantiate RecoveryStrategy having maxRetries=0 and set it to adapter.ActiveRecoveryStrategy but this is overkill.
Why don't you derive from Data Adapter, where you override the method.
Use the derived class when you need the Recovery Strategy, and use the base class where you don't need it.
I derive from dataadapter.
Looks there is no simple way how to disable recovery strategy.
Ok I will live with it.
It's indeed not a turn-key solution, we'll see what we can do about that in the future.
Implemented in v5.7