Add Exception Summarization for Microsoft.Data.SqlClient Exceptions

### Is your feature request related to a problem? Please describe.
Loosely related to #649 and #2342 as these are also about surfacing information about exceptions and the hope is that the result of IsTransient and the ErrorNumber properties would be able to give additional context in a SQL Server specific `IExceptionSummaryProvider` implementation.

### Describe the solution you'd like
[Exception summarization](https://learn.microsoft.com/en-us/dotnet/core/diagnostics/diagnostic-exception-summary) is a new feature of .NET 8. All examples of Exception summarization are configured with `.AddExceptionSummarizer(static builder => builder.AddHttpProvider())`, but when I see this, I instantly think of needing a `.AddExceptionSummarizer(static builder => builder.AddSqlServerProvider())` that would include information like ErrorNumber, if the error is believed to be transient, along with the usual exception summarization.

### Describe alternatives you've considered
* Each project writes their own `IExceptionSummaryProvider` implementation
* A Microsoft.Data.SqlClient.ExceptionSummarization open-source project is started

### Additional context
Likely Microsoft.Data.SqlClient will not want to take a dependency on Microsoft.Extensions.Diagnostics.ExceptionSummarization to be able to implement the IExceptionSummaryProvider interface. This would pretty much require a separate Microsoft.Data.SqlClient.ExceptionSummarization NuGet package to be created, right?