一对多映射流畅 NHibernate

Question

我正在尝试建立一对多关系。我有以下映射：

    public class User
{

    public User()
    {
        UserCourses = new List<UserCourse>();
    }

    public virtual int Id { get; private set; }

    public virtual IList<UserCourse> UserCourses { get; private set;}


}
    public sealed class UserMap : ClassMap<User>
{
    public UserMap()
    {
        Id(x => x.Id, "Id");

        HasMany(x => x.UserCourses).Inverse().Cascade.All().Table("UserCourse");

        Table("[USER]");
    }
}
    public sealed class UserCourseMap : ClassMap<UserCourse>
{
    public UserCourseMap()
    {
        Id(x => x.Id, "Id");

        References(x => x.User, "UserID");

        Map(x => x.Role, "Role");
    }
}

如果我尝试创建 User 对象的实例，然后尝试查看课程，则会出现以下异常：

                var user = (from u in userRepository.Linq() // Fetch a user
                        where u.Username == username
                        select u).Single();

            var courses = user.UserCourses.Single(); // wont work

{“列名“User_id”无效。\r\n列名“User_id”无效。”} 无法初始化集合：[Fringedivision.Rapp.Domain.User.UserCourses#1][SQL: SELECT usercourse0_.User_id as User4_1_, usercourse0_.Id as Id1_, usercourse0_.Id as Id1_0_, usercourse0_.Role as Role1_0_, usercourse0_.UserID作为 UserID1_0_ 来自 [UserCourse] usercourse0_ WHERE usercourse0_.User_id=?]

我似乎不明白问题是什么，有什么建议吗？如果我创建 UserCourse 对象的实例，则引用映射似乎可以工作。

Answer 1

将列添加到 has many

HasMany(x => x.UserCourses).KeyColumn("UserId") 或您所在的 fnh 版本中的实际语法