NHibernate.Cfg.Configuration config = new NHibernate.Cfg.Configuration().AddAssembly("Test.Model");
//通过配置对象来产生一个SessionFactory对象,这是一个Session工厂,
//那么Session是用来干什么的呢?一个Session就是由NHibernate封装
//的工作单元,我们可以近似地认为它起到ADO.Net中Connection的作用。
ISessionFactory factory = config.BuildSessionFactory(); //相当于建立连接
ISession session = factory.OpenSession(); //相当于打开连接
ITransaction trans = session.BeginTransaction(); //相当于申明开始事务
String hql = "update Person p set p.Name='zhang' where p.Id=1";
IQuery query = session.CreateQuery(hql); //相当于建立查询
int ret = query.ExecuteUpdate(); //执行操作
trans.Commit(); //提交事务
//删除
Transaction trans=session.beginTransaction();
String hql=”delete from User user where user.age=18”;
Query queryupdate=session.createQuery(hql);
int ret=queryupdate.executeUpdate();
trans.commit();
//查询
ITransaction trans = session.BeginTransaction();
String hql = "from Person p";
IList query = session.CreateQuery(hql).List();
for (int i = 0; i < query.Count; i++)
{
Person p = (Person)query[i];
Response.Write("<br>"+p.Name);
}
//更新
Transaction trans=session.beginTransaction();
String hql=”update User user set user.age=20 where user.age=18”;
Query queryupdate=session.createQuery(hql);
int ret=queryupdate.executeUpdate();
trans.commit();