Create ASP.NET Web App With SQL Database In Azure

4. Click OK and select ‘MVC’ from ASP.NET templates on the next screen. Click the ‘Change Authentication’ button. Make sure the ‘Host in the Cloud’ checkbox is checked and the ‘Web App’ is selected.

5. Select ‘No Authentication’, OK, then again click OK.
6. If you are not already logged in to Azure, Visual Studio prompts you to do so. Sign in with the ID and password of the account that you use to manage your Azure subscription.
7. Once you're signed in, the Configure Microsoft Azure Web App Setting dialog box asks you what resources you want to create. Provide a unique web app name (this would be the first part of the URL). Select ‘Create a new web service plan’; give some meaningful name. Create a new resource group; give some meaningful name. Select a region based on your location. Click OK.

8. It will take a few seconds to create the project. It will ask to select a source control. If you have TFS or Git configured, you can select one otherwise cancel the popup.

9. Once a project is created, you can check the Azure App service activity window to see details.

10. Build the project.
11. Create a new ADO.NET entity model: Go to Project, then Models, Right click on Models, Add, then New Item. Select ‘ADO.NET Entity Data Model’ from Data, give some name, and click Add.

• Select ‘EF Designer from database’ on the next screen, and click Next.

• Select the ‘Yes, include the sensitive...‘radio button, and then click Next.

• On the next screen, select the ‘CarModels’ table and click Finish


• Entity Model will be created.

• Build the project.
• Now to create a Controller; Go to the Controllers folder, right-click, and Add-> Controller.
• Select ‘MVC 5 Controller with views using Entity Framework’ controller template, and click Add.

• On the next screen- In the Model class drop-down, select CarModel. Select ‘sadautodbEntities’ from the data context drop-down. Ensure all 3 views check boxes are selected, and click Add.

• It will add a controller class ‘CarModelsController’. Do not change anything in this class as it’s already generated by the entity framework with all required actions.

• Now we need to modify the view to link. Navigate to Project -> Views -> Shared. Open _Layout. cshtml and add one <li> as given in the snapshot below.

• Build the project & we are ready to deploy.
• You can hit F5 to deploy locally to test or go ahead with Azure deployment.
Deploy web app to Azure
• In solution explore, select a project, right-click, then Publish. It will open publish web dialog box, click ‘Next’.

• In the configuration, ensure ‘Release’ is selected’ click Next, then Publish. It will take some time to publish on Azure, you can see the process in the output window:

• Once it’s published, it will be opened in the browser. Click on the ‘My Cars’ link in the top navigation, and here you go.

• You can create a new item using ‘Create New Link’.

• Other operations- edit, and delete can also be performed using this page.

• Your web app is in Azure now, anyone with the URL can access this site.