It’s not easy to keep up with tech, here’s an update I missed – you can add params to the connection string to enable retries on connections that were established (in the connection pool) but have since failed. I suspect many apps will cover this in the code that handles deadlocks and other SQL errors, but even if it does I don’t see that enabling this hurts anything.
- https://dpaoliello.wordpress.com/2014/03/30/connection-resiliency-in-ado-net-2/
- https://tudorturcu.wordpress.com/2013/11/11/ado-net-connection-resiliency/
- https://technet.microsoft.com/en-us/library/dn632678.aspx
