关于NHibernate中实现一对多查询的问题

[answerzhang]

啥也不说了出代码
1 Users.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="Bokun.Examples.Model.Users, Bokun.Examples.Model" table="Users">
<id name="ID" type="int" unsaved-value="null">
<column name="ID" length="4" sql-type="int" not-null="true" unique="true" index="PK_Users"/>
<generator class="native" />
</id>
<property name="UserName" type="String">
<column name="UserName" length="50" sql-type="varchar" not-null="false"/>
</property>
<property name="UserPwd" type="String">
<column name="UserPwd" length="50" sql-type="varchar" not-null="false"/>
</property>
<property name="Sex" type="int">
<column name="Sex" length="4" sql-type="int" not-null="false"/>
</property>
<property name="BirthDay" type="DateTime">
<column name="BirthDay" length="8" sql-type="datetime" not-null="false"/>
</property>
<property name="Email" type="String">
<column name="Email" length="50" sql-type="varchar" not-null="false"/>
</property>
<many-to-one name="Postsex" column="Sex" not-null="true" class="Bokun.Examples.Model.sex"/>
</class>
</hibernate-mapping>
2 sex.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="Bokun.Examples.Model.sex, Bokun.Examples.Model" table="sexinfo">
<id name="ID" type="int" unsaved-value="null">
<column name="ID" length="4" sql-type="int" not-null="true" unique="true" index="PK_sex"/>
<generator class="native" />
</id>
<property name="Sex" type="String">
<column name="sex" length="60" sql-type="varchar" not-null="false"/>
</property>
<set name="users" inverse="false">
<key column="sexid"/>
<one-to-many class="Bokun.Examples.Model.Users" />
</set>
</class>
</hibernate-mapping>
3 sex.cs
using System;
using System.Collections.Generic;
using System.Text;
using System.Collections;
using Iesi.Collections.Generic;
namespace Bokun.Examples.Model
{
public class sex
{
public sex()
{ }
private int _id;
private string _sex;

public virtual int ID
{
get { return this._id; }
set { this._id = value; }
}
public virtual string Sex
{
get { return this._sex; }
set { this._sex = value; }
}

private ISet<Users> _users=new HashedSet<Users>();
public virtual ISet<Users> Users
{
get { return this._users; }
set { this._users = value;}
}
}
}
4 Users.cs
using System;
using System.Collections.Generic;
using System.Text;

namespace Bokun.Examples.Model
{
public class Users
{
public Users()
{
}
private int _id;
private string _userName;
private string _userPwd;
private int _sex;
private DateTime _birthDay;
private string _email;

/// <summary>
/// 用户名
/// </summary>
public virtual int ID
{
get { return this._id; }
set { this._id = value; }
}

/// <summary>
/// 用户名
/// </summary>
public virtual string UserName
{
get { return this._userName; }
set { this._userName = value; }
}

/// <summary>
/// 用户密码
/// </summary>
public virtual string UserPwd
{
get { return this._userPwd; }
set { this._userPwd = value; }
}

/// <summary>
/// 性别
/// </summary>
public virtual int Sex
{
get { return this._sex; }
set { this._sex = value; }
}

/// <summary>
/// 出生日期
/// </summary>
public virtual DateTime BirthDay
{
get { return this._birthDay; }
set { this._birthDay = value; }
}

/// <summary>
/// Email
/// </summary>
public virtual string Email
{
get { return this._email; }
set { this._email = value; }
}
/// <summary>
/// 集合类
/// </summary>
private Bokun.Examples.Model.sex _postsex;
public virtual Bokun.Examples.Model.sex Postsex
{
get { return this._postsex; }
set { this._postsex = value;}
}
}
}
请问我想显示全部内容将USERS表中的所有数据显示出来把Sex用文字表示出来应该怎么调用？
另外请帮我看看我上面的代码有问题吗？
谢谢大家 帮忙哦

[answerzhang]

大家帮下忙啊

[answerzhang]

没人来帮下我的忙吗？

[西安风影]

Create Table Parent
(
ParentID int identity primary key,
ParentName varchar(40)
)
Create Table Child
(
ChildID int identity primary key,
ChildName varchar(40),
ParentID int foreign key references Parent(ParentID)
)
protected void Button3_Click ( object sender, EventArgs e )
{
NHibernate.Cfg.Configuration cfg = new NHibernate.Cfg.Configuration ();
cfg.AddAssembly ( "WebNhibernate" );
ISessionFactory factory = cfg.BuildSessionFactory ();
ISession session = factory.OpenSession ();
ITransaction transaction = session.BeginTransaction ();

Parent parent = new Parent ();
parent.ParentName = "Changke";

Child childFirst = new Child ();
childFirst.ChildName = "ChildFirst";
childFirst.Parent = parent;

Child childSecond = new Child ();
childSecond.ChildName = "ChildSecond";
childSecond.Parent = parent;

parent.Childs.Add ( childFirst );
parent.Childs.Add ( childSecond );

session.Save ( parent );
transaction.Commit ();
}

Parent.cs
using System;
using System.Collections.Generic;
using System.Text;

namespace WebNhibernate
{
public class Parent
{
public Parent ()
{
childs = new List<Child> ();
}
private int parentID;
private string parentName;
private IList<Child> childs;

public int ParentID
{
get { return parentID; }
set { parentID = value; }
}

public string ParentName
{
get { return parentName; }
set { parentName = value; }
}

public virtual IList<Child> Childs
{
get { return childs; }
set { childs = value; }
}
}
}

Parent.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="WebNhibernate.Parent,WebNhibernate" table="Parent" lazy="false">
<id name="ParentID" type="Int32">
<generator class="identity"/>
</id>
<property name="ParentName" type="String"/>
<bag name="Childs" lazy="true" inverse="true" cascade="all">
<key column="ParentID"></key>
<one-to-many class="WebNhibernate.Child,WebNhibernate"/>
</bag>
</class>
</hibernate-mapping>

Child.cs
using System;
using System.Collections.Generic;
using System.Text;

namespace WebNhibernate
{
public class Child
{
public Child ()
{
}
private int childID;
private string childName;
private Parent parent;

public int ChildID
{
get { return childID; }
set { childID = value; }
}

public string ChildName
{
get { return childName; }
set { childName = value; }
}

public Parent Parent
{
get { return parent; }
set { parent = value; }
}
}
}

Child.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="WebNhibernate.Child,WebNhibernate" table="Child" lazy="false">
<id name="ChildID" type="Int32" unsaved-value="0">
<generator class="identity" />
</id>
<property name="ChildName" type="String"/>
<many-to-one name="Parent" class ="WebNhibernate.Parent, WebNhibernate" column="ParentID"/>
</class>
</hibernate-mapping>