Entity Framework with MySQL learning note one (complex type Complex Types)

Sometimes we want the column in the SQL table to be divided into another class.

A typical example is the Address

Look directly at the code:

[Table ("member")]     Public classMember {[Key] PublicInt32 MemberID {Get;Set; }  Public stringName {Get;Set; }  Public VirtualAddress Address {Get;Set; } }    /*cannot expose-public dbset<address> addresss {get; set;} <-don ' t does this*/[ComplexType]//Write a label     Public classAddress {/*Be sure to write column here even if the name is the same, because Defaul's naming method is Address_postcode*/[Column ("Postcode")]          Public stringPostcode {Get;Set; } [Column ("Country")]         Public stringCountry {Get;Set; } }

Insert

    DB.MEMBERS.ADD (new  Member    {        "lu Xiao Feng",         New Address        {            "Malaysia",            "81300"         }    });    Db. SaveChanges ();

Entity Framework with MySQL learning note one (complex type Complex Types)