Entity Framework Core生成的存储过程在MySQL中需要进行处理及PMC中的常用命令

在使用Entity Framework Core生成MySQL数据库脚本,对于生成的存储过程,在执行的过程中出现错误,需要在存储过程前面添加

delimiter //

附:可以使用Visual Studio中的程序包管理器控制台执行Entity Framework Core中的迁移命令。

PMC CommandUsage
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命令执行结果:640?wx_fmt=png分享一个关于Entity Framework的网站,希望对大家有帮助:https://www.entityframeworktutorial.net/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值