3.0 Upgrade - Entity with HasNoKey() (formerly a query type) tries to create tables when adding migration

[hallidev]

I have the following Entity which used to be a query type:

modelBuilder
    .Entity<ModQueueEntry>()
    .HasNoKey();

As a query type it caused no issues, but now that it's an entity, migrations are trying to create tables for it.

I have several entities defined like so, none of which attempt table generation when adding a migration. I assume it's because of the ToView():

modelBuilder
    .Entity<AreaUserInfo>()
    .HasNoKey()
    .ToView("v_AreaUserInfos");

The problem is that my above entity types come out of a stored procedure. It's not a View or a Table.

I don't want to have to manually modify every migration going forward to account for this. Is there a way to prevent table generation when creating migrations?

Further technical details

EF Core version: 3.0
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: .NET Core 3.0
Operating system: Windows 10
IDE: Visual Studio 2019 16.3

[bricelam]

Related to #17270 and #2725.

For now, you can just use something like .ToView("You forgot to use FromSql with ModQueueEntry")

[ajcvickers]

Note from triage: closing this as duplicate since the work here is covered by #17270 and #2725.

[be4i]

I am seeing this behavior again with 5.0, ToView(null) is my workaround for now.

builder.Entity<ProductMediaOrdered>(typeBuilder => 
	typeBuilder.HasNoKey();
	typeBuilder.ToInMemoryQuery(() => ...);
)

[francesconi]

Experiencing a similar issue. I've used .HasNoKey().ToView(null) in order to avoid a table creation. Since version 5.0 it now generates a migration with a drop table even if there does not exist one!

[AndriySvyryd]

Call ToTable((string?)null) if you don't want the entity type to be mapped to a table, or call ToTable("MyTable", t => t.ExcludeFromMigrations()) if you want it to be ignored by migrations

[BADF00D]

For some reason I don't know, using the [Keyless] Attribute instead on HasNotKey solved the problem for me

[KillerBoogie]

@AndriySvyryd : I'm using EF Core 6. ToTable(null) results in

CS0121 The call is ambiguous between the following methods or properties: 'RelationalEntityTypeBuilderExtensions.ToTable<TEntity>(EntityTypeBuilder<TEntity>, string?)' and 'RelationalEntityTypeBuilderExtensions.ToTable<TEntity>(EntityTypeBuilder<TEntity>, Action<TableBuilder<TEntity>>)'

I tried .ToTable(null, t => t.ExcludeFromMigrations())
This generated a DropTable in the Up and a CreateTable in the Down.

[AndriySvyryd]

@KillerBoogie Use the view name it was mapped to before: ToTable("MyView", t => t.ExcludeFromMigrations())