EF Core 5包含多个列

public class Address
{
    public string Street { get; set; }
    public string City { get; set; }
    public string State { get; set; }
    public string ZipCode { get; set; }
}

public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
    public Address Address { get; set; }
}

// 在DbContext中配置复杂类型映射
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Customer>()
        .OwnsOne(c => c.Address, a =>
        {
            a.Property(p => p.Street).HasColumnName("Street");
            a.Property(p => p.City).HasColumnName("City");
            a.Property(p => p.State).HasColumnName("State");
            a.Property(p => p.ZipCode).HasColumnName("ZipCode");
        });
}

public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Street { get; set; }
    public string City { get; set; }
    public string State { get; set; }
    public string ZipCode { get; set; }
}

// 在DbContext中配置拆分实体映射
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Customer>()
        .Property(c => c.Street).HasColumnName("Street");
    modelBuilder.Entity<Customer>()
        .Property(c => c.City).HasColumnName("City");
    modelBuilder.Entity<Customer>()
        .Property(c => c.State).HasColumnName("State");
    modelBuilder.Entity<Customer>()
        .Property(c => c.ZipCode).HasColumnName("ZipCode");
}