locked
Azure WebApp AND Azure SQL Access/Tools RRS feed

  • Question

  • Hello All.........I have setup Azure WebApp and Azure SQL for one of our developers.

    Questions:

    1.  What is the easiest way for him to access both so that he can work on building the application?

    2.  Do we need install any tools on his laptop or on Azure for him to access easily?

    3.  If so, what tools are necessary and where to install them?

    4.  Do we need Visual Studio Data Tools on the Azure or on his Laptop for smooth and easy access?

    5.  What is generally used by developers, kindly, suggest.

    6.  Any link to blog, article, guides, etc. would be appreciated.

    Thanks in advance.

     
    Thursday, September 28, 2017 7:33 PM

All replies

  • You can configure Azure web app with existing SQL database.

    Go to your Azure SQL Database and get a copy of the connection string. (It won't have your password, so you'll have to add that).

    Next, go to your Web App, click on the "All Settings" and under then click "Application Settings".

    Scroll down to "Connection Strings" and either create a new connection string (and paste it in from the first step) or update the existing connection string. Be sure to update the password in your connection string.

    If you create a new connection string, make sure it's the same name as that one you are referencing in your code or you will have to change your code and redeploy as that as well.

    You can get the connection string in the app’s web.config file as below:

    -----------------------------------------------------------------------------------------------------

    Do click on "Mark as Answer" on the post that helps you, this can be beneficial to other community members.

    • Proposed as answer by Swikruti Bose Friday, September 29, 2017 5:05 AM
    Friday, September 29, 2017 5:05 AM
  • Thanks for the reply.

    I understand the process the connecting WebApp and SQL together, but thanks for sharing in detail; appreciate it.  My question was more on the working on both of them i.e. day to day work that the developer would be carrying out.  I am adding my understanding in front of questions, would appreciate if you could validate or guide.  Thanks.

    1.  What is the easiest way for him to access both so that he can work on building the application? Through Azure Portal access.

    2.  Do we need install any tools on his laptop or on Azure for him to access easily?  No.

    3.  If so, what tools are necessary and where to install them? None.

    4.  Do we need Visual Studio Data Tools on the Azure or on his Laptop for smooth and easy access?  I am unsure.

    5.  What is generally used by developers, kindly, suggest.  Suggest.

    6.  Any link to blog, article, guides, etc. would be appreciated.

    Thanks in advance.

     

    Friday, September 29, 2017 11:55 AM
    1. You can use the familiar tools in Visual Studio to update your database and web app in Azure. In this step, you use Code First Migrations in Entity Framework to make a change to your database schema and publish it to Azure: https://docs.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-dotnet-sqldatabase#update-app-with-code-first-migrations.
    2. “What is generally used by developers, kindly, suggest.”: Could you explain what exactly are you trying to know (regarding tools or programming language)?
    3. https://docs.microsoft.com/en-us/azure/app-service/containers/tutorial-dotnetcore-sqldb-app.

           https://docs.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-dotnet-sqldatabase

    -----------------------------------------------------------------------------------------------------

    Do click on "Mark as Answer" on the post that helps you, this can be beneficial to other community members.

    Saturday, September 30, 2017 5:38 AM