[Table("T_Member")]
    public class Member
    {
        /// <summary>
        /// 索引ID  对于主键我们推荐使用“ID”或者“ProductID” 也就是“类名+ID”的方式，如此命名EntityFramework会自动的为我们找到表中主键
        /// </summary>
        [Column("F_ID")]
        public Guid ID { get; set; }

        //导航属性 和MemberInfo表是一个一对一的关系
        //通过实际操作，发现在一对一的关系中，我们不适合在两个类中都建立导航属性，
        //可取的操作是在外键表中建立一个导航属性
        //public virtual MemberInfo MemberInfo { get; set; }这个导航属性最后我是删掉的

       //导航属性 和MemberInRole是一个一对多的关系
        public virtual ICollection<MemberInRole> MemberInRole{ get; set; }
        
        /// <summary>
        /// 用户名
        /// </summary>
        [Column("F_Name")]
        [MaxLength(50)]
        public string Name { get; set; }
        
        /// <summary>
        /// 密码
        /// </summary>
        [Column("F_Password")]
        [MaxLength(50)]
        public string Password { get; set; }

        /// <summary>
        /// 真实姓名
        /// </summary>
        [Column("F_TrueName")]
        [MaxLength(50)]
        public string TrueName { get; set; }
    }

[Table("T_MemberInfo")]
    public class MemberInfo
    {
        [Column("F_ID")]
        public Guid ID { get; set; }

        [Column("F_MemberID")]
        public Guid MemberID { get; set; }
        //导航属性 和Member表是一个一对一的关系。只在外键表中建立
        public virtual Member Member { get; set; }
        
        /// <summary>
        /// 姓名拼音
        /// </summary>
        [Column("F_EnTrueName")]
        [MaxLength(50)]
        public string EnTrueName { get; set; }

        /// <summary>
        /// 姓名拼音首字母
        /// </summary>
        [Column("F_EnShortTrueName")]
        [MaxLength(50)]
        public string EnShortTrueName { get; set; }

[Table("T_MemberInfo")]
    public class MemberInfo
    {
        [Column("F_ID")]
        public Guid ID { get; set; }

        [Column("F_MemberID")]
        public Guid MemberID { get; set; }
        //导航属性 和Member表是一个一对一的关系。只在外键表中建立
        public virtual Member Member { get; set; }
        
        /// <summary>
        /// 姓名拼音
        /// </summary>
        [Column("F_EnTrueName")]
        [MaxLength(50)]
        public string EnTrueName { get; set; }

        /// <summary>
        /// 姓名拼音首字母
        /// </summary>
        [Column("F_EnShortTrueName")]
        [MaxLength(50)]
        public string EnShortTrueName { get; set; }

        /// <summary>
        /// 部门ID
        /// 注意MIS.Model.Category表中相应的
        /// </summary>
        
        [Column("F_DepartmentID")]
        public Guid DeparmentID { get; set; }
        

public virtual Category Category { get; set; } ｝

[Table("T_Category")]
    public class Category
    {
        [Column("F_ID")]
        public Guid ID { get; set; }

        [Column("F_Name")]
        [MaxLength(50)]
        public string Name { get; set; }

        [Column("F_ParentID")]
        public Guid ParentID { get; set; }

        [Association("MemberInfo", "ID", "DepartmentID")]

        public virtual ICollection<MemberInfo> MemberInfo { get; set; } 
}

/// <summary>
/// 部门ID
/// 注意MIS.Model.Category表中相应的
/// </summary>

[Column("F_DepartmentID")]
public Guid DeparmentID { get; set; }

public virtual Category Category { get; set; }