entity-framework - Entity Framework Core DbSet 未从数据库返回任何数据

Question

Entity Framework Core DbSet 不从数据库返回任何数据，但数据库有很多寄存器。
这是实体

public class Entity : BaseEntity
{
    public int EntityStatusId { get; set; }
    public int AddressId { get; set; }
    public string Name { get; set; }
    public string SocialReason { get; set; }
    public string CNPJ { get; set; }
    public EntityType Type { get; set; }
    public DateTime? CreationDate { get; set; }
    public bool? ReceiptDisabled { get; set; }
    public EntityStatus EntityStatus { get; set; }
    public Address Address { get; set; }
    public List<Company> Companies { get; set; }
    public List<Role> RoleList { get; set; }
}

public abstract class BaseEntity
{
    public int Id { get; set; }
}

现在这是配置类。

public class EntityMap : IEntityTypeConfiguration<Entity>
{
    public void Configure(EntityTypeBuilder<Entity> builder)
    {
        builder.ToTable("Entity");
        builder.HasKey(entity => entity.Id);
    
        builder
            .Property(entity => entity.EntityStatusId);
        builder
            .Property(entity => entity.AddressId);
        builder
            .Property(entity => entity.Name);
        builder
            .Property(entity => entity.SocialReason);
        builder
            .Property(entity => entity.CNPJ);
        builder
            .Property(entity => entity.Type)
            .HasConversion(x => (int)x, x => (EntityType)x);
        builder
            .Property(entity => entity.CreationDate);
        builder
            .Property(entity => entity.ReceiptDisabled);

        builder
            .HasOne(entity => entity.EntityStatus);
        builder
            .HasOne(entity => entity.Address);
    
        builder
            .HasMany(entity => entity.RoleList)
            .WithOne(x => x.Entity);
        builder
            .HasMany(entity => entity.Companies)
            .WithOne(x => x.Entity);
    }
}

和上下文类。

    public class AucContext : DbContext
    {
        public AucContext(string databaseConfiguration)
        {
            _databaseConfiguration = databaseConfiguration;
        }
        
        private readonly string _databaseConfiguration;

        public DbSet<Campaign> Campaigns { get; set; }
        public DbSet<CampaignProject> CampaignProjects { get; set; }
        public DbSet<Company> Companies { get; set; }
        public DbSet<Cart> Carts { get; set; }
        public DbSet<CartItem> CartItems { get; set; }
        public DbSet<Donation> Donations { get; set; }
        public DbSet<DonationRecurrencePeriod> DonationRecurrencePeriods { get; set; }
        public DbSet<Entity> Entities { get; set; }
        public DbSet<Institution> Institutions { get; set; }
        public DbSet<PaymentMethod> PaymentMethods { get; set; }
        public DbSet<Person> People { get; set; }
        public DbSet<Project> Projects { get; set; }
        public DbSet<User> Users { get; set; }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.ApplyConfiguration(new CampaignMap());
            modelBuilder.ApplyConfiguration(new CampaignProjectMap());
            modelBuilder.ApplyConfiguration(new CompanyMap());
            modelBuilder.ApplyConfiguration(new CartMap());
            modelBuilder.ApplyConfiguration(new CartItemMap());
            modelBuilder.ApplyConfiguration(new DonationMap());
            modelBuilder.ApplyConfiguration(new DonationRecurrencePeriodMap());
            modelBuilder.ApplyConfiguration(new EntityMap());
            modelBuilder.ApplyConfiguration(new InstitutionMap());
            modelBuilder.ApplyConfiguration(new PaymentMethodMap());
            modelBuilder.ApplyConfiguration(new PersonMap());
            modelBuilder.ApplyConfiguration(new ProjectMap());
            modelBuilder.ApplyConfiguration(new UserMap());
        }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer(_databaseConfiguration);
        }
    }

查询很简单

var entity = context.Entities.Find(3)

这个简单的查询没有返回任何内容，对发生的事情有什么想法吗？
更新
我从昨天开始更新了一些东西，现在我更新了问题很遗憾仍然不起作用
OBS:. ConnectionString 没问题，其他对象正常工作。

Answer 1

首先添加Id给您的 Entity :

public int Id { get; set; }

然后在您的 DbContext :
1:在您的 OnModelCreating ，添加

modelBuilder.ApplyConfiguration(new EntityMap());

2:添加数据库集:

public DbSet<Entity> Entity { get; set; }

重新迁移并更新数据库。您的代码将正常工作。