首页 > 代码库 > 实体类上的一对一关系需要手动指定

实体类上的一对一关系需要手动指定

public class User    {        public long UserId { get; set; }        public string UserName { get; set; }        public string UserPwd { get; set; }         public DateTime UserCreateDate { get; set; }        public DateTime LastLoginDate { get; set; }        public DateTime LastActivityDate { get; set; }        public int UserRoleId { get; set; }        public virtual UserRole UserRole { get; set; }        public virtual UserProfile UserProfile { get; set; }    }
public class UserRole    {        public int UserRoleId { get; set; }        public string RoleName { get; set; }    }
public class UserProfile    {        [Key, ForeignKey("User")]        public long UserId { get; set; }        public int Gender { get; set; }        public string NickName { get; set; }        public string Signature { get; set; }        public string Intro { get; set; }        public DateTime? Birth { get; set; }        public string Location { get; set; }        public string Website { get; set; }        public string Qq { get; set; }        public string WeiBo { get; set; }        public string Medals { get; set; }        public string Phone { get; set; }        public string Email { get; set; }        public bool IsSendEmail { get; set; }        public virtual User User { get; set; }    }

一对多的关系可以不用手动指定,就可以直接使用,但是一对一的关系要手动指定后才能进行使用,这里使用了Data Annotation方式配置。添加了[Key, ForeignKey("User")]表明在UserProfile中UserId既是主键,又是来自于"User"的外键。

否则会出现异常

Unable to determine the principal end of an association between the types ‘Model.User’ and ‘Model.UserProfile’. The principal end of this association must be explicitly configured using either the relationship fluent API or data annotations.

实体类上的一对一关系需要手动指定