random connection errors while connect azure sql server

[orionroad]

Describe the bug

hi. I got random errors while connect AzureSQL from production servers

Microsoft.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired

we have no issue when SqlClient 3.1.31 (FileVersion 4.700.22.51706)
after update to 5.2.0, it occurs randomly and 5.2.1.24152.3 still have problems

finllaly, I found same issues below

#2640
#2621
#2471
#2400

Exception message:
Stack trace:

To reproduce

Include a complete code listing (or project/solution) that we can run to reproduce the issue.

Partial code listings, or multiple fragments of code, will slow down our response or cause us to push the issue back to you to provide code to reproduce the issue.

Console.WriteLine("Hello World!");

Expected behavior

A clear and concise description of what you expected to happen.

Further technical details

Microsoft.Data.SqlClient version: (found on the nuget or Microsoft.Data.SqlClient.dll)
.NET Core 8.0.3 / 5.2.1.24152.3
Microsoft Azure SQL
Windows Server 2022 (Azure VM)

Additional context
Add any other context about the problem here.

[orionroad]

<add name="" connectionString="Data Source=windows.net;Initial Catalog=User ID=;Password=;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultipleActiveResultSets=False;MultiSubnetFailover=False;ConnectRetryCount=0;Pooling=False;Max Pool Size=100"
  providerName="Microsoft.Data.SqlClient" />