I am looking for information on the usage of the latest version of the Transient Fault Handling framework with SQL Azure Federation and with Dapper.
I have found some examples with the actual Transient Fault Handling framework here:
But I don't know at which moment I am supposed to execute the "USE FEDERATION..." statement to be sure that I will use the good Federation if the framework does a retry... Where I am supposed to do that?
And also, the "classical" usage of Dapper is easy as you can see here:
We just need a SqlConnection to do a query but will that work well with the Transient Fault Handling framework? If not, I can try to modify the code of Dapper but if I can directly use Azure Federation / Retry framework / Dapper together, that can be great!