ABP-VNext 用户权限管理系统实战01---AuthServer服务迁移数据库到mysql-526互联

一、从github上获取源码后修改命名空间

下载dome后修改解决方案名为Bridge。

二、默认是连接sqlserver的，需要修改为可以连接mysql

修改appsettings.json文件的ConnectionStrings参数，准备一个可以连接的mysql,新建数据库bridge

{
  "ConnectionStrings": {
    "Default": "Server=xxx.xxx.xx.xx;Port=3306; Database=bridge; User=root; Password=xxxx;"
  }
}

三、修改类AuthServerDbContextFactory，使用mysql数据库

using System.IO;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Design;
using Microsoft.Extensions.Configuration;
using Pomelo.EntityFrameworkCore.MySql.Infrastructure;

namespace Bridge.AuthServer.Host.EntityFrameworkCore
{
    public class AuthServerDbContextFactory : IDesignTimeDbContextFactory<AuthServerDbContext>
    {
        public AuthServerDbContext CreateDbContext(string[] args)
        {
            var configuration = BuildConfiguration();
            var builder = new DbContextOptionsBuilder<AuthServerDbContext>();
            builder.UseMySql(configuration.GetConnectionString("Default"),
                  ServerVersion.AutoDetect(configuration.GetConnectionString("Default")));

            return new AuthServerDbContext(builder.Options);
        }

        private static IConfigurationRoot BuildConfiguration()
        {
            var builder = new ConfigurationBuilder()
                .SetBasePath(Directory.GetCurrentDirectory())
                .AddJsonFile("appsettings.json", optional: false);

            return builder.Build();
        }
    }
}