使用 Fluent API 配置/映射属性和类型2

1.将多个实体类映射到数据库中的一个表

   要将多个实体映射到一个数据库表需要满足：

   a. 两个实体必须是一对一关系

   b.两个实体共享一个主键

 public  class MyContext:DbContext
    {
        public MyContext()
            : base("test")
        { }
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Person>()
                .HasRequired(p => p.Detail)
                .WithRequiredPrincipal();
        }
        public DbSet<Person> Persons { get; set; }
        public DbSet<PersonDetail> PersonDetails { get; set; }

    }

    [Table("Person")]
    public class Person
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public bool Sex { get; set; }
        public PersonDetail Detail { get; set; }
    }
    [Table("Person")]
    public class PersonDetail
    {
        [Key,ForeignKey("Person")]
        public int Id { get; set; }
        public DateTime Birth { get; set; }
        public byte[] Photo { get; set; }
        public Person Person { get; set; }
    }
}

 

2.将实体类型的 CLR 属性映射到数据库中的多个表

 public  class MyContext:DbContext
    {
        public MyContext()
            : base("test")
        { }
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Person>()
                .Map(p =>
                {
                    p.Properties(t => new { t.Id, t.Name, t.Sex });
                    p.ToTable("Person");
                })
                .Map(p =>
                {
                    p.Properties(t => new { t.Birth, t.Photo });
                    p.ToTable("PersonDetails2");
                }
                );
        }
        public DbSet<Person> Persons { get; set; } 
    }

    [Table("Person")]
    public class Person
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public bool Sex { get; set; }  
        public DateTime Birth { get; set; }
        public byte[] Photo { get; set; }
    }