[Solved] Azure App Service Error: An exception has been raised that is likely due to a transient failure

We have an MVC5 application whch connects to azure database, it works in local but after deploying in azure app service which has a custom domain configued we get error as "An existing connection was forcibly closed by the remote host.".

From stak trace: An exception has been raised that is likely due to a transient failure. If you are connecting to a SQL Azure database consider using SqlAzureExecutionStrategy.