Summary

In this chapter, we learned about Azure SQL Server and Azure SQL Database, the two different relational database offerings from Azure. This will help you to choose which database type you need to select for a business problem. We learned how to provision Azure SQL databases using the Azure CLI, the Azure portal, and Azure ARM templates, giving you an understanding of a variety of different ways to create and configure Azure SQL Database. Next, we learned about Entity Framework – an ORM framework that helps to interact with SQL Server from ASP.NET Core. In that section, we implemented CRUD operations using the ASP.NET Web API and Entity Framework. We learned about the dependency injection pattern and how it can be used in ASP.NET Core. We also briefly explored EF Core migrations. Finally, we learned about Azure identities, how to create a system-assigned identity, and how identities can be used in Azure SQL Server.

In the next chapter, you will learn about Azure Cosmos...