Can the SqlServerTransientExceptionDetector be moved to System.Data.SqlClient? #13665
Description
The SqlServerTransientExceptionDetector class is really handy to detect if a Sql operation needs to be retried while building anything based on a SqlConnection.
It basically is the core component driving the SqlServerRetryingExecutionStrategy of .NET EF Core. (which used to be the AzureSqlExecutionStrategy in EF)
This logic is sort of replicated also in the Enterprise Library Transient Fault Handling Application Block and then again even in the Elastic database tools for Azure SQL Database
Moving this code 'upstream' would aid a lot to enable reliable operation with Azure Sql with any of the SQL compatible .NET Core Data Access tools out there.
Today we're not falling in the pit of success to run our code on Azure. (We're using Dapper @NickCraver )