ABP vNext 学习系列：修改数据库中表的默认前缀

ABP vNext 学习系列

修改数据库中表的默认前缀

通过系统的xxxDbProperties.DbTablePrefix修改数据库中表的默认前缀。

修改应用的启动程序的模块配置

打开系统的启动程序（一般为xxx.Web或xxx.Host）的模块找到配置函数PreConfigureServices中添加需要修改数据表前缀。如：

        public override void PreConfigureServices(ServiceConfigurationContext context)
        {
            Volo.Abp.IdentityServer.AbpIdentityServerDbProperties.DbTablePrefix = "ids4_";
            Volo.Abp.Identity.AbpIdentityDbProperties.DbTablePrefix = "abp_identity_";

            EasyAbp.PaymentService.PaymentServiceDbProperties.DbTablePrefix = "payment_";
            EasyAbp.PaymentService.Prepayment.PrepaymentDbProperties.DbTablePrefix = "payment_prepayment_";
            EasyAbp.PaymentService.WeChatPay.WeChatPayDbProperties.DbTablePrefix = "payment_WeChatPay_";
            //EasyAbp.WeChatManagement.MiniPrograms.MiniProgramsDbProperties.DbTablePrefix = "wechat_Mini";
            EasyAbp.EShop.EShopDbProperties.DbTablePrefix = "eshop_";
            EasyAbp.EShop.Orders.OrdersDbProperties.DbTablePrefix = "eshop_order_";
            EasyAbp.EShop.Payments.PaymentsDbProperties.DbTablePrefix = "eshop_payments_";
            EasyAbp.EShop.Products.ProductsDbProperties.DbTablePrefix = "eshop_products_";
            EasyAbp.EShop.Stores.StoresDbProperties.DbTablePrefix = "eshop_stores_";
        }

通过VS2019控制台执行数据变更

1. 执行Add-Migration “Update_TablePrefix” ，生成数据变更文件；
2. 执行update-database" ，修改数据表的前缀；

注意事项

必须在已生成数据表结构之后载执行本内容。