在使用Entity Framework Core生成MySQL数据库脚本,对于生成的存储过程,在执行的过程中出现错误,需要在存储过程前面添加
delimiter //
附:可以使用Visual Studio中的程序包管理器控制台执行Entity Framework Core中的迁移命令。
PMC Command | Usage |
---|---|
Get-Help entityframework | 显示有关实体框架命令的信息。 |
Add-migraion <migration name> | 通过添加迁移快照来创建迁移。 |
Remove-Migration | 删除最后一个迁移快照。 |
Update-Database | 根据上一个迁移快照更新数据库架构。 |
Script-Migration | 使用所有迁移快照生成SQL脚本。 |
Scaffold-DbContext | 为指定的数据库生成DbContext和实体类型类。这称为逆向工程。 |
Get-DbContext | 获取有关DbContext类型的信息。 |
Drop-Database | 删除数据库。 |
命令详解:
Get-Help
PM> get-help entityframework
_/\__
---==/ \
___ ___ |. |
| __|| __| | ) \
| _| | _| \_/ | //|\
|___||_| / \/\
TOPIC
about_EntityFrameworkCore
SHORT DESCRIPTION
Provides information about the Entity Framework Core Package Manager Console Tools.
LONG DESCRIPTION
This topic describes the Entity Framework Core Package Manager Console Tools.
See https://docs.efproject.net for information on Entity Framework Core.
The following Entity Framework Core commands are available.
Cmdlet Description
-------------------------- ---------------------------------------------------
Add-Migration Adds a new migration.
Drop-Database Drops the database.
Get-DbContext Gets information about a DbContext type.
Remove-Migration Removes the last migration.
Scaffold-DbContext Scaffolds a DbContext and entity types for a database.
Script-Migration Generates a SQL script from migrations.
Update-Database Updates the database to a specified migration.
SEE ALSO
Add-Migration
Drop-Database
Get-DbContext
Remove-Migration
Scaffold-DbContext
Script-Migration
Update-Database
Add-Migration
NAME
Add-Migration
SYNOPSIS
Adds a new migration.
SYNTAX
Add-Migration [-Name] <String> [-OutputDir <String>] [-Context <String>] [-Project <String>]
[-StartupProject <String>] [<CommonParameters>]
DESCRIPTION
Adds a new migration.
REMARKS
To see the examples, type: "get-help Add-Migration -examples".
For more information, type: "get-help Add-Migration -detailed".
For technical information, type: "get-help Add-Migration -full".
Remove-Migration
NAME
Remove-Migration
SYNOPSIS
Removes the last migration.
SYNTAX
Remove-Migration [-Force] [-Context <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".
Update-Database
NAME
Update-Database
SYNOPSIS
Updates the database to a specified migration.
SYNTAX
Update-Database [[-Migration] <String>] [-Context <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".
Script-migration
NAME
Script-Migration
SYNOPSIS
Generates a SQL script from migrations.
SYNTAX
Script-Migration [-From] <String> [-To] <String> [-Idempotent] [-Output <String>]
[-Context <String>] [-Project <String>] [-StartupProject <String>]
[<CommonParameters>]
Script-Migration [[-From] <String>] [-Idempotent] [-Output <String>] [-Context <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".
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] [-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".
Get-DbContext
NAME
Get-DbContext
SYNOPSIS
Gets information about a DbContext type.
SYNTAX
Get-DbContext [-Context <String>] [-Project <String>] [-StartupProject <String>]
[<CommonParameters>]
DESCRIPTION
Gets information about a DbContext type.
RELATED LINKS
about_EntityFrameworkCore
REMARKS
To see the examples, type: "get-help Get-DbContext -examples".
For more information, type: "get-help Get-DbContext -detailed".
For technical information, type: "get-help Get-DbContext -full".
Drop-Database
NAME
Drop-Database
SYNOPSIS
Drops the database.
SYNTAX
Drop-Database [-Context <String>] [-Project <String>] [-StartupProject <String>]
[-WhatIf] [-Confirm] [<CommonParameters>]
DESCRIPTION
Drops the database.
RELATED LINKS
Update-Database
about_EntityFrameworkCore
REMARKS
To see the examples, type: "get-help Drop-Database -examples".
For more information, type: "get-help Drop-Database -detailed".
For technical information, type: "get-help Drop-Database -full".
get-help命令执行结果:
分享一个关于Entity Framework的网站,希望对大家有帮助:
https://www.entityframeworktutorial.net/