Asp.Net Core CodeFirst 连接MySql

1 安装Nuget包

MySql.Data.EntityFrameworkCore
Microsoft.EntityFrameworkCore.Tools

2 创建实体User

    public class User
    {
        [Key]
        public int Id { get; set; }
        public string Name { get; set; }
        public string Age { get; set; }
    }

3 创建上下文

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

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

4 Startup->ConfigureServices

      var connection = Configuration.GetConnectionString("MySQLConnection");
       services.AddDbContext<ForumDbContext>(options => options.UseMySQL(connection));

5 初始化数据库

#程序包管理器控制台
Add-Migration Init/[自定义名称]
Update-Database
#如果实体发送了修改需要操作执行Migration 命令然后更新
CREATE TABLE `__EFMigrationsHistory`
(
    `MigrationId` nvarchar(150) NOT NULL,
    `ProductVersion` nvarchar(32) NOT NULL,
     PRIMARY KEY (`MigrationId`)
);