entity-framework-core - 具有相同名称的查询类型已存在

Question

The entity type 'MyType' cannot be added to the model because a query type with the same name already exists.

public class MyContext : DbContext
{
    public DbQuery<MyType> MyTypes { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        //Exception is thrown here

        //needed b/c table is not named MyTypes
        modelBuilder.Entity<MyType>()
            .ToTable("MyType");
    }
}

Answer 1

将DbQuery更改为DbSet。 Query Types用于 View among other things。

public class MyContext : DbContext
{
    //DbSet not DbQuery
    public DbSet<MyType> MyTypes { get; set; }
}