EF Core Database First HasNoKey

Question

I have a database table created 20 years ago in my company, it is only used for journaling, with NO PRIMARY KEY or INDEX. I can't alter that table.

I understood that we need to call HasNoKey() in code first approach.

But how can I apply HasNoKey in this case? Since it is a Database First approach.

Solution

In your DbContext class' OnModelCreating method, you do something like this:

modelBuilder
    .Entity<MyEntity>(builder =>
    {
        builder.HasNoKey();
        builder.ToTable("MY_ENTITY");
    });

Read more about it here:
https://docs.microsoft.com/en-us/ef/core/modeling/keyless-entity-types?tabs=fluent-api

Comments

[Ramil Aliyev]

You can check this article docs.microsoft.com/en-us/ef/core/modeling/keyless-entity-typ‌​es

[s k]

No code first approach. The Database was created 20 years ago.

[War]

@sk This should still apply to DB first ... DB first IS code first, it's just that we generate the Entity Types from the DB first, but it should still create a DbContext with a ConfigureModel method in to which we tell the model that this is going on in the DB.

[Slagmoth]

I can't resolve .HasNoKey() on my newly created entity.

[Ricardo Peres]

See docs.microsoft.com/en-us/ef/core/modeling/…