How to setting a model with table don't have any primary key column

Question

On setting DbContext, we have

modelBuilder.Entity<Person>(app =>
{
    app.ToTable("Person");
});

The EFCore throws an exception:

The entity type "Person" requires a primary key to be defined

But our Person table doesn't have any primary key column.

How to avoid this ?

Answer 1

EF Core doesn't support tables without primary keys (aka heaps). The reason is simple: it needs to be able to manipulate individual records, something that cannot be safely achieved without a primary key. As a resolution, you can add a dummy column/primary key of type int/identity or guid/uniqueidentifier, and just ignore it.