Entity Framework Core Cookbook - Second Edition

Dumping the SQL script for the database creation

The migrations API, part of Entity Framework since version 4.1 (Code First) knows how to update the database from the POCO model. Of course, it also knows how to dump the SQL script that it will then execute for that purpose. Sometimes it is important to have a look at that SQL script, and we will see how we can do that.

Getting ready

We will be using NuGet Package Manager to install the Entity Framework Core 1 package, Microsoft.EntityFrameworkCore. We will also be using a SQL Server database for storing the data, so we will also need Microsoft.EntityFrameworkCore.SqlServer.

Finally, xunit is the package we will be using for the unit tests and dotnet-text-xunit adds tooling support for Visual Studio. ...