The Package Manager Console is available within Visual Studio by going to Tools ยป NuGet Package Manager.
If you want to use the Package Manager Console to execute migration commands, you need to ensure that the latest version of Microsoft.EntityFrameworkCore.Tools is added to your project.json file.
The commands that you execute to manage migrations from the Package Manager Console are largely the same as those for Entity Framework 6. The full range of commands can be found by typing get-help entityframework at the PM prompt:
PM> get-help entityframework _/\__ ---==/ \\ ___ ___ |. \|\ | __|| __| | ) \\\ | _| | _| \_/ | //|\\ |___||_| / \\\/\\ TOPIC about_EntityFramework SHORT DESCRIPTION Provides information about Entity Framework commands. LONG DESCRIPTION This topic describes the Entity Framework commands. Entity Framework is Microsoft's recommended data access technology for new applications. The following Entity Framework cmdlets are included. Cmdlet Description -------------------------- --------------------------------------------------- Add-Migration Adds a new migration. Remove-Migration Removes the last migration. Scaffold-DbContext Scaffolds a DbContext and entity type classes for a specified database. Script-Migration Generates a SQL script from migrations. Update-Database Updates the database to a specified migration. Use-DbContext Sets the default DbContext to use. SEE ALSO Add-Migration Remove-Migration Scaffold-DbContext Script-Migration Update-Database Use-DbContext You can get further help for specific commands by typing get-help followed by the command name. For example, the following output is generated as a result of typing get-help Add-Migration:
Add-migration
NAME Add-Migration SYNOPSIS Adds a new migration. SYNTAX Add-Migration [-Name] <String> [-OutputDir <String>] [-Context <String>] [-Project <String>] [-StartupProject <String>] [-Environment <String>] [<CommonParameters>] DESCRIPTION Adds a new migration. Notes
The migration files will be placed in a folder named Migrations by default. This will be created in the root of the project unless an alternative location is specified using the -outputdir switch. If you specify an alternative location with outputdir, the value will be rooted in the project directory. It should not be prefixed with a path separator (e.g. '/').
Remove-Migration
NAME Remove-Migration SYNOPSIS Removes the last migration. SYNTAX Remove-Migration [-Force] [-Context <String>] [-Environment <String>] [-Project <String>] [-StartupProject <String>] [<CommonParameters>] DESCRIPTION Removes the last migration. RELATED LINKS Add-Migration about_EntityFrameworkCore REMARKS To see the examples, type: "get-help Remove-Migration -examples". For more information, type: "get-help Remove-Migration -detailed". For technical information, type: "get-help Remove-Migration -full". Scaffold-DbContext
NAME Scaffold-DbContext SYNOPSIS Scaffolds a DbContext and entity types for a database. SYNTAX Scaffold-DbContext [-Connection] <String> [-Provider] <String> [-OutputDir <String>] [-Context <String>] [-Schemas <String[]>] [-Tables <String[]>] [-DataAnnotations] [-Force] [-Environment <String>] [-Project <String>] [-StartupProject <String>] [<CommonParameters>] DESCRIPTION Scaffolds a DbContext and entity types for a database. RELATED LINKS about_EntityFrameworkCore REMARKS To see the examples, type: "get-help Scaffold-DbContext -examples". For more information, type: "get-help Scaffold-DbContext -detailed". For technical information, type: "get-help Scaffold-DbContext -full". Script-Migration
NAME Script-Migration SYNOPSIS Generates a SQL script from migrations. SYNTAX Script-Migration [-From] <String> [-To] <String> [-Idempotent] [-Context <String>] [-Environment <String>] [-Project <String>] [-StartupProject <String>] [<CommonParameters>] Script-Migration [[-From] <String>] [-Idempotent] [-Context <String>] [-Environment <String>] [-Project <String>] [-StartupProject <String>] [<CommonParameters>] DESCRIPTION Generates a SQL script from migrations. RELATED LINKS Update-Database about_EntityFrameworkCore REMARKS To see the examples, type: "get-help Script-Migration -examples". For more information, type: "get-help Script-Migration -detailed". For technical information, type: "get-help Script-Migration -full". Notes
The script-migration command will script all migrations, regardless of whether they have been applied or not. If you only want to script the most recent migration, the value to apply to the -from switch is the last migration that was applied. You can read -from as meaning "after", not "including".
Update-Database
NAME Update-Database SYNOPSIS Updates the database to a specified migration. SYNTAX Update-Database [[-Migration] <String>] [-Context <String>] [-Environment <String>] [-Project <String>] [-StartupProject <String>] [<CommonParameters>] DESCRIPTION Updates the database to a specified migration. RELATED LINKS Script-Migration about_EntityFrameworkCore REMARKS To see the examples, type: "get-help Update-Database -examples". For more information, type: "get-help Update-Database -detailed". For technical information, type: "get-help Update-Database -full". 
FAQ Chat