Hello Sir,
Is it possible to remove "Abp" prefix from the table name? For example: I want my table to be call AuditLogs instead of AbpEditLogs.
I thought this could be accomplish by updating the migration scripts before running "Update-Database" in the Package Manager Console. I did a search and replace all instances of "dbo.AbpEditLogs" to "dbo.EditLogs" on all the scripts.
The "Update-Database" was able to apply all the migration, however it failed when it attempt run the Seed method.
Error message:
System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.AbpEditions'.
...
...
at MyTestAbpProject.Migrations.SeedData.DefaultEditionsBuilder.CreateEditions() in C:\MyTestAbpProject\MyTestAbpProject.EntityFramework\Migrations\SeedData\DefaultEditionsBuilder.cs:line 24
at MyTestAbpProject.Migrations.SeedData.DefaultEditionsBuilder.Build() in C:MyTestAbpProject\MyTestAbpProject.EntityFramework\Migrations\SeedData\DefaultEditionsBuilder.cs:line 19
at MyTestAbpProject.Migrations.SeedData.InitialDataBuilder.Build() in C:\MyTestAbpProject\MyTestAbpProject.EntityFramework\Migrations\SeedData\InitialDataBuilder.cs:line 19
at MyTestAbpProject.Migrations.Configuration.Seed(MyTestAbpProjectDbContext context) in C:\MyTestAbpProject\MyTestAbpProject.EntityFramework\Migrations\Configuration.cs:line 16
at System.Data.Entity.Migrations.DbMigrationsConfiguration1.OnSeed(DbContext context) at System.Data.Entity.Migrations.DbMigrator.SeedDatabase() at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.SeedDatabase() at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable1 pendingMigrations, String targetMigrationId, String lastMigrationId)
at
...
...
Looking at DefaultEditionsBuilder.cs line# 24, var defaultEdition = _context.Editions.FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
Did find implementation on _context.Editions which eventually lead me to
namespace Abp.Application.Editions { [Table("AbpEditions")] public class Edition : FullAuditedEntity
It appears that the [Table("AbpEditions")] is in your Apb library and I have no way of removing the "Abp" table prefix.
Is there a workaround?
Thanks in advance for your help. -Peter
6 Answer(s)
-
0
You should be able to change the name of your table during OnModelCreating. You can overwrite DataAnnotation of the table name . Code-First gives precedence to Fluent API > data annotations > default conventions.
protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<AuditLog>().ToTable("AuditLogs "); } -
0
<cite>Omar: </cite> You should be able to change the name of your table during OnModelCreating. You can overwrite DataAnnotation of the table name . Code-First gives precedence to Fluent API > data annotations > default conventions.
protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<AuditLog>().ToTable("AuditLogs "); }How to handle the derived entities which actually are mapped with Table-per-type strategy? For example, in the default project
RolePermissionSettingand
UserPermissionSettingare both mapped to
AbpPermissionstable. How can we mapped these inheritance relationships?
-
0
I have the same problem too... Anyone helps...
-
0
Have you tried overriding modelBuilder as described above. You can make it for also derived entities.
-
0
Thanks for your reply. Could we define a solution for this, because i really want to use your current entities. I thought a solution: FlexibleTableNameAttribute : TableNameAttribute And in that attribute, we use a resource file for TableName, all table name will be handle in 1 file. When someone want to change TableName, it will be easier :D Currently, we don't know how many TableName existed in AbpFramework. With me, i must run update-database and see how many table in database to figure out.
Thanks and best regards
-
0
OK, get the code: <a class="postlink" href="https://gist.github.com/hikalkan/4f8f793c7929a81d300f">https://gist.github.com/hikalkan/4f8f793c7929a81d300f</a>
