切换数据库

当前默认数据库是mysql
以下操作将演示如何切换数据库,从mysql切换到sqlserver
其它数据库流程类似，Oracle可能需要额外修改

如何切换到SqlServer

在Directory.Build.Volo.targets添加Volo.Abp.EntityFrameworkCore.SqlServer NuGet包

xml

<ItemGroup>
    <PackageReference Update="Volo.Abp.EntityFrameworkCore.SqlServer" Version="8.3.3"/>
</ItemGroup>

修改Lion.AbpPro.EntityFrameworkCore层nuget包引用

xml

<ItemGroup>
    <!-- <PackageReference Include="Volo.Abp.EntityFrameworkCore.MySQL" /> -->
    <!-- mysql切换为sqlserver -->
    <PackageReference Include="Volo.Abp.EntityFrameworkCore.SqlServer"  />
</ItemGroup>

调整Lion.AbpPro.EntityFrameworkCore层的模块依赖

csharp

    [DependsOn(
        typeof(AbpProDomainModule),
        typeof(BasicManagementEntityFrameworkCoreModule),
        // typeof(AbpEntityFrameworkCoreMySQLModule),
          // mysql切换为sqlserver 
         typeof(AbpEntityFrameworkCoreSqlServerModule),
        typeof(DataDictionaryManagementEntityFrameworkCoreModule),
        typeof(NotificationManagementEntityFrameworkCoreModule),
        typeof(LanguageManagementEntityFrameworkCoreModule)
        )]
    public class AbpProEntityFrameworkCoreModule : AbpModule
   {
        public override void PreConfigureServices(ServiceConfigurationContext context)
        {
            AbpProEfCoreEntityExtensionMappings.Configure();
        }

        public override void ConfigureServices(ServiceConfigurationContext context)
        {
            context.Services.AddAbpDbContext<AbpProDbContext>(options =>
            {
                options.AddDefaultRepositories(includeAllEntities: true);
            });
            
            Configure<AbpDbContextOptions>(options =>
            {
                // options.UseMySQL();
                // mysql切换为sqlserver 
                options.UseSqlServer();
            });
        }
    }
}

修改Lion.AbpPro.EntityFrameworkCore层下的AbpProMigrationsDbContextFactory

csharp

// var builder = new DbContextOptionsBuilder<AbpProDbContext>()
//                 .UseMySql(configuration.GetConnectionString("Default"), MySqlServerVersion.LatestSupportedServerVersion);
    <!-- mysql切换为sqlserver -->
var builder = new DbContextOptionsBuilder<AbpProDbContext>().UseSqlServer(configuration.GetConnectionString("Default"));

删除Lion.AbpPro.EntityFrameworkCore层下Migrations的所有文件
修改Lion.AbpPro.DbMigrator下的appsettings.json数据库连接字符串为SqlServer连接字符串
在Lion.AbpPro.EntityFrameworkCore层下执行迁移命令

bash

dotnet ef migrations add Initial

运行Lion.AbpPro.DbMigrator
修改Lion.AbpPro.HttpApi.Host项目的数据库字符串为SqlServer连接字符串
运行Lion.AbpPro.HttpApi.Host项目
迁移完成,用户名：admin 密码：1q2w3E*

切换数据库 ​

如何切换到SqlServer ​

切换数据库

如何切换到SqlServer