How to connect an asp.net webapp to a an sql database

This is a documentation showing how to connect an asp.net app service to an azure sql database

to carry out this Project, I used the following tools

1. Visual studio 2023
2. A to do list app source code written in html , javascript and css.

To connect an asp.net web app to sql database, we will go through the following steps:

Create a new project

1. Open visual Studio 2023 and click on new project
2. select ASP.net core web app
3. click on next

1. I named the application MyFirstAzureWebApp, and then selected Next.
2. Select .NET 7.0 (Standard-term support).
3. Set Authentication to None and create as shown below

1. From the Visual Studio menu, select Debug > Start Without Debugging to run the web app locally. If you see a message asking you to trust a self-signed certificate, select Yes.

Publish the app

1. look Solution Explorer at the left hand side , right-click the MyFirstAzureWebApp project and select Publish.
2. In Publish, select Azure and then Next.

1. Choose the Specific target, Azure App Service (Linux) Then, select Next

1. To publish your app, you need an account. I signed into my account by clicking on the sign in button to use your Azure subscription.

1. For Subscription, I select the subscription already listed
   since that is the subscription I am using

2. For Resource group, I select my resource group gracewebapp

3. For hosting plan, I clicked on the one with my webapp name

4. Select Create to create the Azure resources.

Once the wizard completes, the Azure resources are created for you, and you're ready to publish your ASP.NET Core project.

In the Publish dialog, ensure your new App Service app is selected, then select Finish, then select Close. Visual Studio creates a publish profile for you for the selected App Service app.

In the Publish page, select Publish. If you see a warning message, select Continue.

1. Update the app and redeploy

2. In Solution Explorer, I open Index.cshtml.

3. I replaced the

   element with my html ,css and javascript code as shown below

   

   Save your changes.

   1. To redeploy to Azure, right-click the MyFirstAzureWebApp project in Solution Explorer and select Publish.

   2. In the Publish summary page, select Publish.

   3. After a successful publishing completes, Visual Studio opens a browser with the webapp showing

   

   Manage the Azure app

   1. Go to Azure portal , then go to appservice, look for the app MyFirstAzureWebApp

   

   1. Select the name of the name of the app and the picture below is showed

   

   Connecting to SQL Database

   1. Create an sql database. I already have one from creating a web app + database

   2. Go to your sql database, select connection string

   3. navigate to ADO.net and copy the value

   

   1. go to the app service you just deployed, navigate to configuration

   2. click on create new connection string

   

   1. Under name, enter dbconnection

   2. under value, paste the value you just copied form the sqldatabase ado.net.

   3. under type, select sql server.

   

   click on ok

   Our app service has ben successfully connected to a Azure SQL database