更新时间: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)