December 2019
Intermediate to advanced
494 pages
11h 41m
English
Another option you can use to connect to your Azure SQL Database is using Entity Framework (EF). Create another .NET Core console application and install the Microsoft.EntityFrameworkCore.SqlServer package using NuGet. EF Core only supports code-first, although you can scaffold existing databases. This basically means that you'll need all your tables, views, and stored procedures in code as well. The downside is obviously that this is a bit of work, although scaffolding does this for you. The upside to this is that you'll always be able to generate your database from code. This allows you to use migrations, which incrementally build your database from code. For the first example, let's simply recreate ...