Microsoft have recently released a long awaited retry mechanism for .NET SqlClient
I’m a fan of Polly for retry logic:
Polly is a library that allows developers to express resilience and transient fault handling policies such as Retry, Circuit Breaker, Timeout, Bulkhead Isolation, and Fallback in a fluent and thread-safe manner.
It will be interesting to see how they compare in terms of ease of use.