Thanks for this Peter, but I am currently only interested in having retry on the Open connection, since that is what we currently have, and i don't want to refactor all existing queries.
Preferably I would just replace the current scoped connection with a wrapper, that used the retry policy in my first post, when dapper tries to open the connection.