且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

实体框架复杂类型在一个模型中的多个实例?

更新时间:2022-10-14 22:52:23

通过EF 6,$ C C首先$当您使用相同的复杂类型的多个实例,如

  PersonalAddress_Street
BusinessAddress_Street
...
 

等。你只需要映射旧版本的EF。映射选项还可以让你的东西更好替换这些自动生成的名字。

另外,我不认为这是正确的配置code根据您的模型(错字也许?):

  this.Property(T => t.PersonalAddress.Address.Street)
// 应该
this.Property(T => t.PersonalAddress.Street)
 

Is there a way to have multiple instances of complex type inside the same model using Fluent api model builder?

public class Contact
{
     public int Id { get; set; }
     public string FirstName { get; set; }
     public string LastName { get; set; }

     public Address PersonalAddress { get; set; }
     public Address BusinessAddress { get; set; }
}

public class Address
{
     public string Street{ get; set; }
     public string City{ get; set; }
     public string PostalCode{ get; set; }
}


protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
     base.OnModelCreating(modelBuilder);

     modelBuilder.Configurations.Add(new ContactConfiguration());
     modelBuilder.Configurations.Add(new AddressConfiguration());
}

==================================================================================

public class AddressConfiguration : ComplexTypeConfiguration<Address>
{
    public AddressConfiguration()
    {

        //props
        this.Property(t => t.Street)
            .IsOptional()
            .HasColumnName("AddressStreet")
            .HasMaxLength(1024);

        this.Property(t => t.PostalCode)
            .IsOptional()
            .HasColumnName("AddressPostalCode")
            .HasMaxLength(64);

        this.Property(t => t.City)
            .IsOptional()
            .HasColumnName("AddressCity")
            .HasMaxLength(512);
    }
}

EDIT (FOUND THE SOLUTION)

If multiple complex type class instances are used in same CF Model, configuration of these classes is set at CF Model level like this:

public class ContactConfiguration : EntityTypeConfiguration<Contact>
{
    public ContactConfiguration()
    {

        //props for PersonalAddress instance of Address complex type class
        this.Property(t => t.PersonalAddress.Address.Street)
            .HasColumnName("PersonalAddressStreet");

        this.Property(t => t.PersonalAddress.Address.PostalCode)
            .HasColumnName("PersonalAddressPostalCode");

        this.Property(t => t.PersonalAddress.Address.City)
            .HasColumnName("PersonalAddressCity");


        //props for BusinessAddress instance of Address complex type class
        this.Property(t => t.BusinessAddress.Address.Street)
            .HasColumnName("BusinessAddressStreet");

        this.Property(t => t.BusinessAddress.Address.PostalCode)
            .HasColumnName("BusinessAddressPostalCode");

        this.Property(t => t.BusinessAddress.Address.City)
            .HasColumnName("BusinessAddressCity");
    }
}

With EF 6, Code First will prefix the column names with your Property name when you use multiple instances of same complex type, like

PersonalAddress_Street
BusinessAddress_Street
...

and so on. You only need the mappings older versions of EF. The mapping option also allows you to replace these autogenerated names with something nicer.

Also, I don't think this is the correct configuration code based on your models (typo maybe?):

this.Property(t => t.PersonalAddress.Address.Street)
// should be
this.Property(t => t.PersonalAddress.Street)