EF Core Fluent API设置接口的所有列类型 [英] Ef core fluent api set all column types of interface

问题描述

不幸的是，ef内核不支持TPC模式，但是我们需要这种行为。我编写了一个称为IBase的接口，每个实体都实现了该接口：

Unfortunately ef core does not support TPC-pattern, but we need this kind of behaviour. I´ve wrote an interface which is called IBase and each entity implements this interface:

public interface IBase
{
    Guid Id { get; set; }

    [Column(TypeName = "datetime2")]
    DateTime CreateDate { get; set; }

    [Required]
    [StringLength(255)]
    string CreateUser { get; set; }

    bool Deleted { get; set; }
}

我想摆脱注解以使用Fluent API配置。但是我有大约20个不同的实体和7个基值，我不想一遍又一遍地进行相同的配置：

I want to get rid of Annotations to use the Fluent API configuration instead. But I have about 20 different entities and 7 Base-Values and I don´t want to make the same configuration over and over again:

 modelBuilder.Entity<SomeEntity>()
            .Property(e => e.CreateDate)
            .HasColumnType("datetime2(2)")
            .IsRequired();

有什么想法可以为所有实施IBase的实体配置一次基本属性吗？

Any ideas how to configure each Base-Property once for all entities implementing IBase?

推荐答案

EF核心可以很好地与基类/继承结合使用，因此只需创建一个基类，然后将通用的东西放入其中，然后从中继承您的模型像这样的基类：

EF core perfectly fine with base classes/inheritance, so just create an base generic class and put common things into it and then inherit your models from those base class like that:

public abstract class BaseModel<TId>
{
    TId Id { get; set; }

    [Column(TypeName = "datetime2")]
    DateTime CreateDate { get; set; }

    [Required]
    [StringLength(255)]
    string CreateUser { get; set; }

    bool Deleted { get; set; }
}

class Model : BaseModel<Guid>{ ... //model specific stuff }

---

如果使用fluentapi对您来说至关重要，那么存在一个名为 IEntityTypeConfiguration< TModel>的配置接口; ，您所需要的只是再次创建基本配置，然后从中继承特定配置。然后在您的 DbContext.OnModelCreating 方法中应用这些配置，如下所示：

---

If for some reason it's deadly important for you to use fluentapi than there is a configuration interface exists called IEntityTypeConfiguration<TModel> and all what you need is again create base configuration and latter inherit specific configurations from it. And after that apply those configurations in your DbContext.OnModelCreating method somewhat like that:

class BaseConfiguration<TBaseModel> : IEntityTypeConfiguration<TBaseModel>
{
    public virtual void Configure(EntityTypeBuilder<TBaseModel> builder)
    {
        builder.Property...
    }
}

class ModelConfiguration : BaseConfiguration<Model>
{
    public override void Configure(EntityTypeBuilder<Model> builder)
    {
         base.Configure(builder)
         ...// model specific stuff
    }
}

class CustomDbContext : DbContext
{
    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
        modelBuilder.ApplyConfiguration(new ModelConfiguration());
    }
}

这篇关于EF Core Fluent API设置接口的所有列类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！