Microsoft.EntityFrameworkCore.Database.Connection: An error occurred using the connection to database

[sankarnarayanan100895]

I am getting following error: Microsoft.EntityFrameworkCore.Database.Connection: An error occurred using the connection to database '' on server 'tcp:.database.windows.net,1433'. intermittently.

We use .NET 8.0 in our project.
We deploy our service in AKS (Linux container) and connect to Azure SQL database.
The SQL related nuget packages we use are

Why I am getting above error in a randomly fashion. This is happening both in case user password connection as well managed identity connection

[pedro-cons]

Here are key possible causes and how to address them:

1 - Missing database name in connection string

2 - Intermittent network issues in AKS

3 - Throttling in Managed Identity