Migration Conventions

Question

I have an MVC DDD application that uses Sqlserver.

I’m trying to get the database to Postgressql, but there is a FK duplicity error.

For example, the default Sqlserver would be generated:

FK_dbo.Adicao_dbo.OrgaoEmissorAtoLegal_ExTarifOrgEmissorAtoLegaLegalId
FK_dbo.Adicao_dbo.OrgaoEmissorAtoLegal_ExTarifOrgEmissorAtoLegalId

But in Postgressql when generating FK he tends to do:

FK_dbo.Adicao_dbo.OrgaoEmissorAtoLegal_ExTarifOrgEmissorAtoLega -- ambas iguais

It is possible to apply another rule in FK generation automatically?
Someone’s already done it?

Answer 1

According to the documentation, an identifier may only be up to 63 characters long.

Need to use foreign key with smaller name. Try to use an annottation in the generation of it to decrease the name.

From what I’ve seen you use Fluent. You can use an alternative modeling for cases using postgresql instead of sql server.

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
        modelBuilder.Entity<Post>()
            .HasOne(p => p.Blog)
            .WithMany(b => b.Posts)
            .HasForeignKey(p => p.BlogId)
            .HasConstraintName("ForeignKey_Post_Blog");
 }