Entity Framework with MySQL 學習筆記一(複雜類型 Complex Types)

標籤：style   blog   color   os   sp   div   on   log   代碼   

有時候我們希望在sql一個表裡面的column, 一部分被分化成另一個class 

典型的例子是 Address 

直接看代碼:

    [Table("member")]    public class Member    {        [Key]        public Int32 memberId { get; set; }        public string name { get; set; }               public virtual Address address { get; set; }    }    /*        不能公開 - public DbSet<Address> addresss { get; set; } <-don‘t do this    */    [ComplexType] //寫一個標籤    public class Address    {             /*            這裡一定要寫 column 即使名字一樣，因為defaul的命名法是 Address_postcode         */        [Column("postcode")]         public string postcode { get; set; }        [Column("country")]        public string country { get; set; }    }

insert 

    db.members.Add(new Member    {        name = "lu xiao feng",        address = new Address        {            country = "MALAYSIA",            postcode = "81300"        }    });    db.SaveChanges();

 

Entity Framework with MySQL 學習筆記一(複雜類型 Complex Types)