Chapter 7
- What is Azure SQL Database?
Azure SQL Database is a hosted SQL database service in Azure. It runs on the SQL Server database engine. There are some important differences between Azure SQL Database and the traditional SQL Server. But most database administrators using SQL Server are able to migrate to Azure SQL Database. Azure SQL Database makes it extremely easy to scale a database. We are able to replicate a database in one or more locations around the world, which can improve performance if your application is used worldwide.
- How do we connect Azure SQL Database to an ASP.NET app?
To connect Azure SQL Database to an ASP.NET app, we start by creating and configuring the database connection, and we use Visual Studio 2022 and SQL Server Object Explorer. For more details about the different steps, see Exercise 4 – connecting Azure SQL Database to an ASP.NET app.