How can I change database table prefix? #699

alper created 4 years ago

Support Team Director

Each module can define its database table prefix. For example Blog module sets its database table as Blg. This is done in the module. See BloggingDbProperties.cs . If you want to overwrite this prefix you can do it in your Domain Module class as below.

Volo.Blogging.BloggingDbProperties.DbTablePrefix  = "Xyz"

For Identity Server module you can set it as below

Volo.Abp.IdentityServer.AbpIdentityServerDbProperties.DbTablePrefix = "Ids";

This behavour is same for other modules as well.

The essential framework modules have Abp prefix. Check out the documentation https://docs.abp.io/en/abp/latest/Entity-Framework-Core-Migrations#table-prefixes

In your application, your table prefix is App by default. You can change this in the following file: Acme.BookStore\src\Acme.BookStore.Domain\BookStoreConsts.cs

namespace Acme.BookStore
{
    public static class BookStoreConsts
    {
        public const string DbTablePrefix = "Xyz"; //<----- this is the variable to set your table prefix

        public const string DbSchema = null;
    }
}

This change requires the re-creation of migrations. To do this; delete your existing migrations in the Migrations folder Acme.BookStore.EntityFrameworkCore.DbMigrations\Migrations\ and then add migrations using add-migration Initial

1 Answer(s)