Writing and reading data from Azure SQL Database using .NET Core and EF Core

In this section, we will learn how to interact with Azure SQL Database from the .NET Core application. We will learn about connecting to the SQL Server database using Entity Framework Core (EF Core) and implementing Create, Read, Update, Delete (CRUD) operations.

Connecting to Azure SQL Database from ASP.NET Core

In this section, we will learn about connecting to Azure SQL Database from an ASP.NET Core Web API application. We will be using the EF Core library to interact with Azure SQL Database.

Introducing EF Core

EF is an object-relational mapping (ORM) framework – a programming technique used to represent relational database entities to classes and objects, which helps developers work with databases without writing SQL code. Along with the .NET Core release, Microsoft introduced EF Core. Microsoft offers EF Core providers for databases such as MS SQL Server, Cosmos DB, and SQLite. Additionally...