NHibernate 多主键设置

数据库结构,3个字段,StudentName, ClassName, ClassDate,都为char类型,主键为StudenName + ClassName。

配置文件:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
  <class name="CompoTest.Classes, CompoTest" table="Classes">
      <composite-id class="CompoTest.ClassInfo, CompoTest" name = "MyClassInfo">
          <key-property name="StudentName" type="String(10)" column="StudentName" />
          <key-property name="ClassName" type="String(10)" column="ClassName" />
      </composite-id>
      <property name="ClassDate" type="String(8)" column="ClassDate" />
  </class>
</hibernate-mapping>
类:

public class Classes
{
public Classes()
{

}

private System.String _ClassDate;
public System.String ClassDate
{
  get { return _ClassDate; }
  set { _ClassDate = value; }
}

private ClassInfo classInfo;
public ClassInfo MyClassInfo
{
  get { return classInfo; }
  set { classInfo = value; }
}

}

public class ClassInfo
{
public ClassInfo()
{
}

private string studentName;
public string StudentName
{
  set { studentName = value; }
  get { return studentName; }
}

private string className;
public string ClassName
{
  set { className = value; }
  get { return className; }
}
}
写几个测试用例

[Test]
public void TestAdd()
{
  ClassInfo classInfo = new ClassInfo();
  classInfo.ClassName = "Chinese";
  classInfo.StudentName = "Tom";

  Classes classes = new Classes();
  classes.ClassDate = "20041003";
  classes.MyClassInfo = classInfo;
 

  Configuration cfg = new Configuration();
  cfg.AddXmlFile("Classes.hbm.xml");
  ISessionFactory factory = cfg.BuildSessionFactory();
  ISession session = factory.OpenSession();
  ITransaction transaction = session.BeginTransaction();
 
 
  session.Save(classes);
  transaction.Commit();
  session.Close();

}


[Test]
public void TestUpdate()
{
  ClassInfo classInfo = new ClassInfo();
  classInfo.ClassName = "Chinese";
  classInfo.StudentName = "Tom";
 
  Classes classes = new Classes();
 
  Configuration cfg = new Configuration();
  cfg.AddXmlFile("Classes.hbm.xml");
  ISessionFactory factory = cfg.BuildSessionFactory();
  ISession session = factory.OpenSession();
  ITransaction transaction = session.BeginTransaction();

  classes = (Classes)session.Load(typeof(Classes),classInfo);
  classes.ClassDate = "20041231";

  session.Save(classes);

  transaction.Commit();
  session.Close();
}

[Test]
public void TestDelete()
{
  ClassInfo classInfo = new ClassInfo();
  classInfo.ClassName = "Chinese";
  classInfo.StudentName = "Tom";
 
  Classes classes = new Classes();
 
  Configuration cfg = new Configuration();
  cfg.AddXmlFile("Classes.hbm.xml");
  ISessionFactory factory = cfg.BuildSessionFactory();
  ISession session = factory.OpenSession();
  ITransaction transaction = session.BeginTransaction();

  classes = (Classes)session.Load(typeof(Classes),classInfo);
  session.Delete(classes);

  transaction.Commit();
  session.Close();
}
posted @ 2009-12-02 17:45    阅读(453)  评论(0编辑  收藏  举报