Menu
I'm create a web app using Asp.net core with EntityFramework core, but the Update-Database command no longer has the "-Script" switch. How can I get the sql script? Thanks.
392
What Is Entity Framework Core? Entity Framework Core is the new version of Entity Framework after EF 6.x. It is open-source, lightweight, extensible, and a cross-platform version of Entity Framework data access technology. Entity Framework is an Object/Relational Mapping (O/RM) framework.
Entity Framework Core Code First. Code First. If you have used Entity Framework in the past, you will probably have heard about the Code First approach. Code First workflow begins with classes that describe the conceptual model and then Entity Framework generate a database from that model automatically. Code first approach offers most control ...
The EF Core packages required for migration will be added with .NET Core project setup. Let’s install the Microsoft.EntityFrameworkCore.Tools package and run the following command in the Package Manager console: This will create the classes for supporting migrations. Now let’s apply those changes to the database.
Now you can see in the below image that our column is now not accepted a null value. Delete table from database using entity framework core code first approach is so simple you have to remove or comment that table from context file, add migration and then update the database. Now you can see that your table is removed from your database.
Run this command to produce the SQL Script
> dotnet ef migrations script -o fileName.sql
Also there's a powershell command for it too: powershell#script-migration
82
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
