EFCore Code First生成数据库SOP步骤

public partial class SmsPush
    {
        [Key]
        public int Id { get; set; }
        [MaxLength(128)]
        public string AppName { get; set; }

        [DataType(DataType.Text)]
        public string TargetValue { get; set; }

        [DataType(DataType.Text)]
        public string Content { get; set; }

        [DataType(DataType.DateTime)]
        public DateTime CreateTime { get; set; }
    }

public class MvcMovieContext : DbContext
    {
        public MvcMovieContext (DbContextOptions<MvcMovieContext> options)
            : base(options)
        {
        }

        public DbSet<Movie> Movie { get; set; }
    }

services.AddDbContext<PushContext>(options =>
            {
                options.UseMySQL(Configuration.GetConnectionString("PushContext"));
            });

{
  "ConnectionStrings": {
    "PushContext": "Persist Security Info=False;database=push-center;server=localhost;Connect Timeout=30;user id=root; pwd=111111"
  }
}

#安装mysql
choco install mysql
#遇到让你选择是否运行脚本，Y/A 按着走

#第三行
$url = ‘https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-winx64.zip‘
#替换为搜狐镜像 类似还有
#网易 http://mirrors.163.com/
#中科大 http://mirrors.ustc.edu.cn/
#清华 https://mirrors.tuna.tsinghua.edu.cn/
$url = ‘http://mirrors.sohu.com/mysql/MySQL-8.0/mysql-8.0.20-winx64.zip‘

# 修改密码
# 初次安装mysql，root账户没有密码。直接登录
mysql -u root
mysql>show databases;
mysql>set password for ‘root‘@‘localhost‘ =password(‘设置你的密码‘);
Query OK, 0 rows affected (0.00 sec)
#不需要重启数据库即可生效

mysql -u root

#初始化root账户的密码
mysql>ALTER USER root@localhost IDENTIFIED BY ‘123456‘;

#第一步
Add-Migration InitialCreate

#第二步
Update-Database

No type was specified for the decimal column ‘Price‘ on entity type ‘Movie‘. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using ‘HasColumnType()‘.

public class MoviesController : Controller
{
    private readonly MvcMovieContext _context;

    public MoviesController(MvcMovieContext context)
    {
        _context = context;
    }
}

#先检查下
Get-Help about_EntityFrameworkCore
PM> Get-Help about_EntityFrameworkCore

                     _/\__
               ---==/    \         ___  ___   |.    \|        | __|| __|  |  )   \\        | _| | _|   \_/ |  //|\        |___||_|       /   \\\/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-DbContext            Generates a SQL script from the current DbContext.

        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-DbContext
    Script-Migration
    Update-Database

#上面是包没问题的象征，如果有问题，再执行如下命令
Install-Package Microsoft.EntityFrameworkCore.Tools

# POCO类修改=>修改数据表
# 给本次迁移取一个名字：UpdateEditions，初始化取的名字:InitialCreate
Add-Migration UpdateEditions

# 更新
Update-Database

# 突然发现可能有影响，那就回滚吧，删除上一次迁移（回滚针对迁移进行的代码更改）
Remove-Migration