Azure Connectivity Fix on .NET WebApp
Budget: $10 – $100 AUD
I have an Microsoft MVC Web App with a target framework of .NET 8.0 that accesses a Microsoft SQL Database on my local machine.
I am using Entityframework as well as Dapper to access the database.
Everything runs successfully on the local machine.
I have uploaded the local Web App to an Azure Web App using a compressed *.zip file.
I have uploaded the local SQL Database to an Azure SQL Database using a *.bacpac file and restored the database.
I have added the correct secrets to an Azure Key Vault.
Everything works on my local machine.
From Azure the Web App opens as expected and I can view all static pages correctly.
I am unable to connect from the Azure Web App to the Azure SQL Database.
I keep getting the following error
.......[03:29:46 ERR] An exception occurred while iterating over the results of a query for context type 'Onion.Data.ApplicationDbContext'.
.......System.InvalidOperationException: The ConnectionString property has not been initialized.
I understand its a connection string issue and maybe also a firewall rule issue.
I require a genius to just talk me through these issues so i can successfully retrieve data from the database.
Also i would like to use Entra ID passwordless for the final Azure Web App.
Also i would like to use Entra ID passwordless for the final Azure Web App.
I am using Entityframework as well as Dapper to access the database.
Everything runs successfully on the local machine.
I have uploaded the local Web App to an Azure Web App using a compressed *.zip file.
I have uploaded the local SQL Database to an Azure SQL Database using a *.bacpac file and restored the database.
I have added the correct secrets to an Azure Key Vault.
Everything works on my local machine.
From Azure the Web App opens as expected and I can view all static pages correctly.
I am unable to connect from the Azure Web App to the Azure SQL Database.
I keep getting the following error
.......[03:29:46 ERR] An exception occurred while iterating over the results of a query for context type 'Onion.Data.ApplicationDbContext'.
.......System.InvalidOperationException: The ConnectionString property has not been initialized.
I understand its a connection string issue and maybe also a firewall rule issue.
I require a genius to just talk me through these issues so i can successfully retrieve data from the database.
Also i would like to use Entra ID passwordless for the final Azure Web App.
Also i would like to use Entra ID passwordless for the final Azure Web App.