Efcore: Primary key name not taken into account when scaffolding

[roji]

Originally raised by @WarrenFerrell in https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/538#issuecomment-407422154.

When scaffolding primary key constraints, the constraint name currently seems to be ignored. In other words, scaffolding the following table:

c# CREATE TABLE my_table ( id INTEGER, CONSTRAINT table_pk PRIMARY KEY (id) );

results in a model where the constraint name isn't set. If the database is recreated from this model, the PK constraint is called PK_my_table rather than table_pk, which is great if round-trippability is a goal. I've verified and the DatabasePrimaryKey returned by NpgsqlDatabaseModelFactory indeed contains the correct constraint name.

I'm guessing this is probably the case for other constraint types (foreign key, unique).

[smitpatel]

Only case with PK. AK/Index/FK works correctly.

[smitpatel]

We need to do similar to this in VisitPrimaryKey and VisitUniqueConstraint (which is also slightly buggy)

https://github.com/aspnet/EntityFrameworkCore/blob/5c8600e440498e992a7fc3c02d447534fc146334/src/EFCore.Design/Scaffolding/Internal/RelationalScaffoldingModelFactory.cs#L600-L604

Would you like to send a PR @roji ?

[roji]

Sure, if @bricelam doesn't mind giving this up, although it might take me a bit of time to get around to it...

[bricelam]

It'll take me a while to get around to it too, so just whoever gets to it first...

[roji]

Submitted https://github.com/aspnet/EntityFrameworkCore/pull/12836

[OskarKlintrot]

Sorry for posting on a closed issue but I'm having a similar problem to this. I'm trying to use EF Core on an existing database that has a table with this schema:

CREATE TABLE [dbo].[Example] (
    [Id]                  INT                IDENTITY (1, 1) NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

However EF Core reverse engineers the table to

CREATE TABLE [dbo].[Example] (
    [Id]                  INT                IDENTITY (1, 1) NOT NULL,
    CONSTRAINT [PK_Example] PRIMARY KEY CLUSTERED ([Id] ASC)
);

Is there any way, using fluent api for example, to get rid of the name and constraint so that it actually matches the schema of the existing database? I'm not sure the constraint name actually matters in real life? It gives me a lot of false diffs though when I use SqlSchemaCompare in VS to make sure the new entities matches the database.

[shvmgpt116]

@roji @ajcvickers This issue seems to be present in 2.1 code line of EFCore (I verified it with 2.1.11 and 2.1.14 version of EFCore). Since 2.1 is an LTS, is there any plan to backport the fix to 2.1 code line?

[ajcvickers]

@shvmgpt116 We have no plans to port this change to 2.1. At this point in 2.1's release cycle it would have to be an extremely serious issue to be ported there.