{"id":3020,"date":"2020-01-27T21:50:46","date_gmt":"2020-01-27T20:50:46","guid":{"rendered":"https:\/\/www.codemotion.com\/magazine\/?p=3020"},"modified":"2022-07-08T15:36:02","modified_gmt":"2022-07-08T13:36:02","slug":"use-azure-sql-database-in-your-web-app","status":"publish","type":"post","link":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/","title":{"rendered":"Use Azure SQL database in your web app"},"content":{"rendered":"\n<p class=\"eplus-pO2ZCH\">In a <a href=\"https:\/\/www.codemotion.com\/magazine\/dev-hub\/cloud-manager\/a-first-web-app-on-microsoft-azure\/\" class=\"ek-link\">previous article<\/a>, we described how to create an Azure <span id=\"urn:enhancement-65e1720f\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/web_application\">Web App<\/span> for your <span id=\"urn:enhancement-7ddd221f\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/web_application\">web application<\/span> from scratch. This article explains how to add an Azure SQL database to an app and manage it through the Azure Portal. To complete these steps, you will need an <strong>active<\/strong> Microsoft Azure Subscription.<\/p>\n\n\n\n<h2 class=\"eplus-MKClqI wp-block-heading\" id=\"h-what-is-azure-sql-database\">What is Azure SQL Database<\/h2>\n\n\n\n<p class=\"eplus-aNVngF\">Azure SQL is included in the Microsoft Azure Platform-as-a-Service (PaaS) offer, which lets you create SQL Server instances and databases. It is <strong>highly scalable<\/strong> and can be used to help manage massive workloads, if needed. This service is also <strong>compatible<\/strong> with <a href=\"https:\/\/www.codemotion.com\/magazine\/dev-hub\/data-scientist\/data-warehouse-implementations-best-practices\/\" target=\"_blank\" rel=\"noopener\">SQL Server<\/a> on-premises instances. Some appealing features are:<\/p>\n\n\n\n<ul class=\"eplus-BmRvmO wp-block-list\"><li>Instance management through the Azure portal;<\/li><li>Simple scaling model;<\/li><li>Straightforward security configuration;<\/li><li>Simple migration from an on-premises environment to a cloud instance;<\/li><li>Auto-tuning thanks to the built-in machine learning engine;<\/li><\/ul>\n\n\n\n<p class=\"eplus-EyfHob\">Using on-premises instances can be <strong>challenging<\/strong>: firstly, you need to have a <span id=\"urn:enhancement-562257e3\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/virtual_machine\">virtual machine<\/span> or a physical server with a well-defined hardware and software configuration. Even if these options can be tweaked for a <span id=\"urn:enhancement-5c676b78\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/virtual_machine\">virtual machine<\/span>, you cannot achieve the flexibility of a cloud environment. Also, security aspects have to be addressed, such as operating system updates and networking configuration. Other concerns include high availability and data recovery, not always an easy task to maintain. Azure SQL offers <strong>many advantages<\/strong> that on-premises cases generally do not &#8211; <span id=\"urn:enhancement-9580d4a4\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/microsoft\">Microsoft<\/span> manages the hardware and the <span id=\"urn:enhancement-35b904fb\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/operating_system\">operating system<\/span> patches <strong>directly<\/strong>. In terms of scaling,  you can quickly increase the compute size on your instance if more power is needed. Furthermore, Azure SQL provides a built-in <strong>firewall<\/strong> that helps manage ingoing connections through a configuration page, on which you can identify the IP addresses authorized to access the <span id=\"urn:enhancement-cc6943ab\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">database<\/span>. <\/p>\n\n\n\n<h2 class=\"eplus-x7U66P wp-block-heading\" id=\"h-create-an-azure-sql-database\">Create an Azure SQL Database<\/h2>\n\n\n\n<p class=\"eplus-G13Fwz\">Once logged into the Azure Portal using your account, click on the &#8216;Create a Resource&#8217; button in the side menu to open the &#8216;New&#8217; section.<\/p>\n\n\n\n<div class=\"wp-block-image  eplus-b0iMzV\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image01-804x1024.png\" alt=\"\" class=\"wp-image-3021\"\/><figcaption> Add a new Azure SQL database <\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"eplus-Wk7RuW\"> Clicking on the SQL <span id=\"urn:enhancement-ecca3283\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">Database<\/span> link will show the Azure SQL creation wizard.<\/p>\n\n\n\n<div class=\"wp-block-image  eplus-S9btLm\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image02-893x1024.png\" alt=\"\" class=\"wp-image-3022\"\/><figcaption> Create a new Azure SQL database wizard <\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"eplus-DVBRG6\">In this section, select a <strong>subscription<\/strong>, a <strong>resource group<\/strong> (if already available), and a <strong>database name<\/strong>. Next, click on the &#8216;Create new&#8217; link in the Server field. A popup will open, in which you&#8217;ll need to set the server instance configuration.<\/p>\n\n\n\n<div class=\"wp-block-image  eplus-AFh5q5\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"477\" height=\"675\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image03.png\" alt=\"\" class=\"wp-image-3023\" srcset=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image03.png 477w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image03-212x300.png 212w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><figcaption> Server Instance configuration <\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"eplus-1JWpYO\"><strong>Elastic pools<\/strong> can be ignored for now. This feature allows sharing instance resources among multiple <span id=\"urn:enhancement-43c9475f\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">databases<\/span> inside the same pool.<\/p>\n\n\n\n<h3 class=\"eplus-3RfeVp wp-block-heading\" id=\"h-pricing-model\">Pricing Model<\/h3>\n\n\n\n<p class=\"eplus-T5Jmvl\">Finally, click on the &#8216;Compute + Storage&#8217; setting. <span id=\"urn:enhancement-d27ab8f\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/microsoft\">Microsoft<\/span> Azure offers two different purchasing models: the <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-service-tiers-dtu\"><strong>Database transaction unit (DTU)-based purchasing model<\/strong><\/a> (DTU) and the <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-service-tiers-vcore\"><strong>Virtual core (vCore)-based purchasing model<\/strong><\/a>. The main difference is that while the first bundles compute and storage resources into a set of predefined configurations, the second offers more <strong>flexibility<\/strong> by selecting resources in a more granular way. <strong>vCores<\/strong> are actual <em>virtual cores<\/em>, and this purchasing model lets you scale compute or memory resources <strong>independently<\/strong>. The purchasing model used in this article is DTU-based. Click on the &#8216;Configure <span id=\"urn:enhancement-710cfd22\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">Database<\/span>&#8216; link and choose the &#8216;Basic, Standard, or Premium&#8217; section.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-yhdN6C\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"316\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image04-1024x316.png\" alt=\"\" class=\"wp-image-3024\" srcset=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image04-1024x316.png 1024w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image04-300x93.png 300w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image04-768x237.png 768w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image04.png 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption> Purchasing models <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-PbDTZH\">In the <strong>Basic<\/strong> configuration, set the instance parameters as in the following image:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-xopj81\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"337\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image05-1024x337.png\" alt=\"\" class=\"wp-image-3025\" srcset=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image05-1024x337.png 1024w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image05-300x99.png 300w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image05-768x253.png 768w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image05.png 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption> DTU-based purchasing model <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-KQ3Onc\">The page shows an <strong>estimated monthly cost<\/strong>. Save the configuration and proceed to the Networking tab, confirming default settings.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-5ziwFx\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"589\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image06-1024x589.png\" alt=\"\" class=\"wp-image-3026\" srcset=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image06-1024x589.png 1024w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image06-300x172.png 300w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image06-768x441.png 768w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image06.png 1496w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption> Networking tab <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-ssiHSJ\">In the &#8216;Additional Settings&#8217; tab, it is possible to define the <strong>database collation<\/strong>: this parameter establishes the comparison <a href=\"https:\/\/azure.microsoft.com\/es-mx\/blog\/working-with-collations-in-sql-azure\/\">rules<\/a> used when ordering or comparing data (i.e., case sensitive or case insensitive).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-9OZBle\"><img decoding=\"async\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image07-899x1024.png\" alt=\"\" class=\"wp-image-3027\"\/><figcaption> Database collation <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-y1hKYR\"> Click on the &#8216;Review + Create&#8217; button to start the <strong>provisioning<\/strong> of the <span id=\"urn:enhancement-bb4025b5\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">database<\/span>. Once completed, you can access the resource page.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-OHdAb7\"><img decoding=\"async\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image08-1024x261.png\" alt=\"\" class=\"wp-image-3028\"\/><figcaption> Deployment completed <\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-Wn2mFU\"><img decoding=\"async\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image09-1024x188.png\" alt=\"\" class=\"wp-image-3029\"\/><figcaption> Azure SQL database page <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-JKEdMo\"> It is important to know that when the SQL <span id=\"urn:enhancement-38e26165\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">Database<\/span> is created, a new database instance is created, too: this is a logical container that can manage <strong>multiple <span id=\"urn:enhancement-f0ec1f2b\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">databases<\/span>, accounts, firewall rules, and so on.<\/strong><\/p>\n\n\n\n<h2 class=\"eplus-mx710k wp-block-heading\" id=\"h-connect-to-azure-sql-database\">Connect to Azure SQL database<\/h2>\n\n\n\n<p class=\"eplus-eL220e\">Before connecting to the <span id=\"urn:enhancement-8c68e068\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">database<\/span>, you need to configure the <strong>firewall<\/strong> to allow incoming connections. By clicking on the &#8216;Set server firewall&#8217; button on the database page, you can add <strong>a client IP<\/strong> or <strong>enable Azure Resources<\/strong> to access the DB, as in the following image:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-KDNeh3\"><img decoding=\"async\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image10-1024x749.png\" alt=\"\" class=\"wp-image-3030\"\/><figcaption> Azure SQL Firewall configuration <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-g1HqSa\">There are many tools to connect to the <span id=\"urn:enhancement-9ebcda06\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">database<\/span>, such as SQL Server Management, Visual Studio, Visual Studio Code, and Cloud Shell. In this article, you will download <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/download?view=sql-server-ver15\">Azure Data Studio<\/a>, which is a cross-platform <span id=\"urn:enhancement-8bc1187c\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/integrated_development_environment\">IDE<\/span> to manage Azure SQL databases. After installation is complete, select &#8216;New connection&#8217;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-zczPRq\"><img decoding=\"async\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image11-650x1024.png\" alt=\"\" class=\"wp-image-3031\"\/><figcaption> Azure Data Studio welcome page  <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-v3WyRK\"> The <span id=\"urn:enhancement-818b9779\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/integrated_development_environment\">IDE<\/span> opens a connection popup to type database info: <\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-8cbkpe\"><img loading=\"lazy\" decoding=\"async\" width=\"769\" height=\"675\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image12.png\" alt=\"\" class=\"wp-image-3032\" srcset=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image12.png 769w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image12-300x263.png 300w\" sizes=\"auto, (max-width: 769px) 100vw, 769px\" \/><figcaption> Database connection details <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-vhHpME\"> Clicking the &#8216;Connect&#8217; button will connect to the empty <span id=\"urn:enhancement-74899f99\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">database<\/span>. <\/p>\n\n\n\n<h2 class=\"eplus-c4q4gw wp-block-heading\" id=\"h-connect-your-app-to-azure-sql\">Connect your app to Azure SQL<\/h2>\n\n\n\n<p class=\"eplus-ZxuOBr\">If you have SQL scripts available to create and seed your <span id=\"urn:enhancement-3bff9c9d\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">database<\/span>, you can use Azure Data Studio to accomplish that, but for the purposes of this article, you can try to download a working ASP.NET MVC application that uses <strong>Entity Framework<\/strong>. Entity Framework (EF for short) is an <a href=\"https:\/\/en.wikipedia.org\/wiki\/Object-relational_mapping\"><strong>O\/RM<\/strong><\/a> that helps you to manage <strong>persistence<\/strong> for the domain of your application. The sample to download can be found <a href=\"https:\/\/github.com\/aspnet\/AspNetCore.Docs\/tree\/master\/aspnetcore\/tutorials\/first-mvc-app\/start-mvc\/sample\/2.2-completed\">here<\/a>. <strong>Visual Studio Code<\/strong> can be used to open the application folder and restore packages or build the <span id=\"urn:enhancement-bc055482\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/project\">project<\/span>, as in the last <a href=\"https:\/\/www.codemotion.com\/magazine\/dev-hub\/cloud-manager\/a-first-web-app-on-microsoft-azure\/\">article<\/a>. The first step is to replace the <strong>MvcMovieContext<\/strong> connection string in the <strong>appsettings.json<\/strong> file with the one available on the Azure SQL portal page.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-TMsAqw\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"399\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image13-1024x399.png\" alt=\"\" class=\"wp-image-3033\" srcset=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image13-1024x399.png 1024w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image13-300x117.png 300w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image13-768x300.png 768w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image13.png 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption> Updating the Connection string <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-YOScdK\">Next, build and run the <span id=\"urn:enhancement-3333e572\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/project\">project<\/span> using the <strong>.NET CLI<\/strong> to check if the connection is working (as explained in the previous article). If the connection is working, you should see some data on the movie page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-ekkJwK\"><img decoding=\"async\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image14-1024x426.png\" alt=\"\" class=\"wp-image-3034\"\/><figcaption> Data are retrieved from the database <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-RGduqb\">During the first execution, the Entity Framework will create and seed the <span id=\"urn:enhancement-1a550f95\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">database<\/span>. Also, querying the Movie table in Azure Data Studio shows a few rows. Using this mechanism, named <strong>migrations<\/strong>,<strong> <\/strong>you can add more tables or data to the <span id=\"urn:enhancement-62fd573b\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/database\">database<\/span>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large  eplus-Pcvy0B\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"611\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image15-1024x611.png\" alt=\"\" class=\"wp-image-3035\" srcset=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image15-1024x611.png 1024w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image15-300x179.png 300w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image15-768x458.png 768w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/image15.png 1132w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption> Querying the Movie table <\/figcaption><\/figure>\n\n\n\n<p class=\"eplus-PYLKy8\"> Finally, you can deploy the app to an <strong>Azure <span id=\"urn:enhancement-e522eff2\" class=\"textannotation disambiguated wl-thing\" itemid=\"http:\/\/data.wordlift.io\/wl01770\/entity\/web_application\">Web App<\/span><\/strong> to test whether it connects to the Azure SQL database.<\/p>\n\n\n\n\n\n<p><em>Recommended article<\/em>: <a href=\"https:\/\/www.codemotion.com\/magazine\/ai-ml\/big-data\/will-nosql-survive-big-data\/\" target=\"_blank\" aria-label=\"Will NoSQL Survive Big Data? (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\">Will NoSQL Survive Big Data?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In a previous article, we described how to create an Azure Web App for your web application from scratch. This article explains how to add an Azure SQL database to an app and manage it through the Azure Portal. To complete these steps, you will need an active Microsoft Azure Subscription. What is Azure SQL&#8230; <a class=\"more-link\" href=\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/\">Read more<\/a><\/p>\n","protected":false},"author":9,"featured_media":2340,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":5,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","_uag_custom_page_level_css":"","_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[5244],"tags":[4139,3360,62],"collections":[],"class_list":{"0":"post-3020","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-cloud","8":"tag-azure","9":"tag-database","10":"tag-dot-net","11":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v26.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Use Azure SQL database in your web app - Codemotion Magazine<\/title>\n<meta name=\"description\" content=\"Learn how to create an Azure SQL database, and how to use it in your web applications.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use Azure SQL database in your web app\" \/>\n<meta property=\"og:description\" content=\"Learn how to create an Azure SQL database, and how to use it in your web applications.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/\" \/>\n<meta property=\"og:site_name\" content=\"Codemotion Magazine\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Codemotion.Italy\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-27T20:50:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-08T13:36:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1013\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Antonio Turibbio Liccardi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@turibbio\" \/>\n<meta name=\"twitter:site\" content=\"@CodemotionIT\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antonio Turibbio Liccardi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/\"},\"author\":{\"name\":\"Antonio Turibbio Liccardi\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/7e8f9aade09a4e3ba0ba01c0eaa1a0a0\"},\"headline\":\"Use Azure SQL database in your web app\",\"datePublished\":\"2020-01-27T20:50:46+00:00\",\"dateModified\":\"2022-07-08T13:36:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/\"},\"wordCount\":1025,\"publisher\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg\",\"keywords\":[\"Azure\",\"Database\",\"Dot NET\"],\"articleSection\":[\"Cloud\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/\",\"name\":\"Use Azure SQL database in your web app - Codemotion Magazine\",\"isPartOf\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg\",\"datePublished\":\"2020-01-27T20:50:46+00:00\",\"dateModified\":\"2022-07-08T13:36:02+00:00\",\"description\":\"Learn how to create an Azure SQL database, and how to use it in your web applications.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#primaryimage\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg\",\"contentUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg\",\"width\":1013,\"height\":675,\"caption\":\"Azure functions & Azure Durable functions\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.codemotion.com\/magazine\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DevOps\",\"item\":\"https:\/\/www.codemotion.com\/magazine\/devops\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Cloud\",\"item\":\"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Use Azure SQL database in your web app\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#website\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/\",\"name\":\"Codemotion Magazine\",\"description\":\"We code the future. Together\",\"publisher\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.codemotion.com\/magazine\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#organization\",\"name\":\"Codemotion\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png\",\"contentUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png\",\"width\":225,\"height\":225,\"caption\":\"Codemotion\"},\"image\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Codemotion.Italy\/\",\"https:\/\/x.com\/CodemotionIT\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/7e8f9aade09a4e3ba0ba01c0eaa1a0a0\",\"name\":\"Antonio Turibbio Liccardi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/71a132e506f96e21890c26c9f5a2c7c95e1650374779bf23a824e7adf5448868?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/71a132e506f96e21890c26c9f5a2c7c95e1650374779bf23a824e7adf5448868?s=96&d=mm&r=g\",\"caption\":\"Antonio Turibbio Liccardi\"},\"description\":\"I'm a book author and trainer working as Cloud Developer and DevOps Engineer at Blexin. I love sharing, so I co-founded \u201cDotNetCampania\u201d (an Italian .NET community), to help other developers to improve their knowledge about .NET Ecosystem and coding in general. I'm also a frequent speaker at conferences, and I've been awared by Microsoft as MVP for Visual Studio Developer Technologies since 2015.\",\"sameAs\":[\"https:\/\/x.com\/turibbio\"],\"url\":\"https:\/\/www.codemotion.com\/magazine\/author\/antonio-turibbio-liccardi\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Use Azure SQL database in your web app - Codemotion Magazine","description":"Learn how to create an Azure SQL database, and how to use it in your web applications.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/","og_locale":"en_US","og_type":"article","og_title":"Use Azure SQL database in your web app","og_description":"Learn how to create an Azure SQL database, and how to use it in your web applications.","og_url":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/","og_site_name":"Codemotion Magazine","article_publisher":"https:\/\/www.facebook.com\/Codemotion.Italy\/","article_published_time":"2020-01-27T20:50:46+00:00","article_modified_time":"2022-07-08T13:36:02+00:00","og_image":[{"width":1013,"height":675,"url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg","type":"image\/jpeg"}],"author":"Antonio Turibbio Liccardi","twitter_card":"summary_large_image","twitter_creator":"@turibbio","twitter_site":"@CodemotionIT","twitter_misc":{"Written by":"Antonio Turibbio Liccardi","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#article","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/"},"author":{"name":"Antonio Turibbio Liccardi","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/7e8f9aade09a4e3ba0ba01c0eaa1a0a0"},"headline":"Use Azure SQL database in your web app","datePublished":"2020-01-27T20:50:46+00:00","dateModified":"2022-07-08T13:36:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/"},"wordCount":1025,"publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg","keywords":["Azure","Database","Dot NET"],"articleSection":["Cloud"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/","url":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/","name":"Use Azure SQL database in your web app - Codemotion Magazine","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#primaryimage"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg","datePublished":"2020-01-27T20:50:46+00:00","dateModified":"2022-07-08T13:36:02+00:00","description":"Learn how to create an Azure SQL database, and how to use it in your web applications.","breadcrumb":{"@id":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#primaryimage","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg","width":1013,"height":675,"caption":"Azure functions & Azure Durable functions"},{"@type":"BreadcrumbList","@id":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/use-azure-sql-database-in-your-web-app\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.codemotion.com\/magazine\/"},{"@type":"ListItem","position":2,"name":"DevOps","item":"https:\/\/www.codemotion.com\/magazine\/devops\/"},{"@type":"ListItem","position":3,"name":"Cloud","item":"https:\/\/www.codemotion.com\/magazine\/devops\/cloud\/"},{"@type":"ListItem","position":4,"name":"Use Azure SQL database in your web app"}]},{"@type":"WebSite","@id":"https:\/\/www.codemotion.com\/magazine\/#website","url":"https:\/\/www.codemotion.com\/magazine\/","name":"Codemotion Magazine","description":"We code the future. Together","publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.codemotion.com\/magazine\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.codemotion.com\/magazine\/#organization","name":"Codemotion","url":"https:\/\/www.codemotion.com\/magazine\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png","width":225,"height":225,"caption":"Codemotion"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Codemotion.Italy\/","https:\/\/x.com\/CodemotionIT"]},{"@type":"Person","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/7e8f9aade09a4e3ba0ba01c0eaa1a0a0","name":"Antonio Turibbio Liccardi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/71a132e506f96e21890c26c9f5a2c7c95e1650374779bf23a824e7adf5448868?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/71a132e506f96e21890c26c9f5a2c7c95e1650374779bf23a824e7adf5448868?s=96&d=mm&r=g","caption":"Antonio Turibbio Liccardi"},"description":"I'm a book author and trainer working as Cloud Developer and DevOps Engineer at Blexin. I love sharing, so I co-founded \u201cDotNetCampania\u201d (an Italian .NET community), to help other developers to improve their knowledge about .NET Ecosystem and coding in general. I'm also a frequent speaker at conferences, and I've been awared by Microsoft as MVP for Visual Studio Developer Technologies since 2015.","sameAs":["https:\/\/x.com\/turibbio"],"url":"https:\/\/www.codemotion.com\/magazine\/author\/antonio-turibbio-liccardi\/"}]}},"featured_image_src":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000-600x400.jpg","featured_image_src_square":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000-600x600.jpg","author_info":{"display_name":"Antonio Turibbio Liccardi","author_link":"https:\/\/www.codemotion.com\/magazine\/author\/antonio-turibbio-liccardi\/"},"uagb_featured_image_src":{"full":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg",1013,675,false],"thumbnail":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000-150x150.jpg",150,150,true],"medium":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000-300x200.jpg",300,200,true],"medium_large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000-768x512.jpg",768,512,true],"large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg",1013,675,false],"1536x1536":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg",1013,675,false],"2048x2048":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg",1013,675,false],"small-home-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000.jpg",100,67,false],"sidebar-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000-180x128.jpg",180,128,true],"genesis-singular-images":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000-896x504.jpg",896,504,true],"archive-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000-400x225.jpg",400,225,true],"gb-block-post-grid-landscape":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000-600x400.jpg",600,400,true],"gb-block-post-grid-square":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2020\/01\/sky-1867902_1280_c3e50973dfdb83f43870c1d60bc1e973_2000-600x600.jpg",600,600,true]},"uagb_author_info":{"display_name":"Antonio Turibbio Liccardi","author_link":"https:\/\/www.codemotion.com\/magazine\/author\/antonio-turibbio-liccardi\/"},"uagb_comment_info":0,"uagb_excerpt":"In a previous article, we described how to create an Azure Web App for your web application from scratch. This article explains how to add an Azure SQL database to an app and manage it through the Azure Portal. To complete these steps, you will need an active Microsoft Azure Subscription. What is Azure SQL&#8230;&hellip;","lang":"en","_links":{"self":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/3020","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/comments?post=3020"}],"version-history":[{"count":6,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/3020\/revisions"}],"predecessor-version":[{"id":18261,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/3020\/revisions\/18261"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media\/2340"}],"wp:attachment":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media?parent=3020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/categories?post=3020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/tags?post=3020"},{"taxonomy":"collections","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/collections?post=3020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}