Nhibernate学习入门

using System;
using System.Collections.Generic;
using System.Text;
namespace NhibernateSample1
{
public class User
{
private int _id;
private string _name;
private string _pwd;
/**//// <summary>
/// 编号
/// </summary> 
public virtual int Id
{
get
{
return _id;
}
set
{
_id = value;
}
}
/**//// <summary>
/// 名称
/// </summary> 
public virtual string Name
{
get
{
return _name;
}
set
{
_name = value;
}
}
/**//// <summary>
/// 密码
/// </summary> 
public virtual string Pwd
{
get
{
return _pwd;
}
set
{
_pwd = value;
}
}
}
}

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="NhibernateSample1.User,NhibernateSample1" table="Users" lazy="false">
<id name="Id" column="Id" unsaved-value="0">
<generator class="native" />
</id>
<property name="Name" column="Name" type="string" length="64" not-null="true" unique="true"></property>
<property name="Pwd" column="Pwd" type="string" length="64" not-null="true"></property>
</class>
</hibernate-mapping>

using System;
using System.Web;
using NHibernate;
using NHibernate.Cfg;

namespace NhibernateSample1
...{
public sealed class NHibernateHelper
...{
private static readonly ISessionFactory sessionFactory;

static NHibernateHelper()
...{
sessionFactory = new Configuration().Configure(@"E:\my project\nhibernate study\simle 1\NHibernateStudy1\NhibernateSample1\hibernate.cfg.xml").BuildSessionFactory();
}

public static ISession GetCurrentSession()
...{
ISession currentSession = sessionFactory.OpenSession();
return currentSession;
}

public static void CloseSessionFactory()
...{
if (sessionFactory != null)
...{
sessionFactory.Close();
}
}
}
}

using System;
using System.Collections.Generic;
using System.Text;
using NHibernate;
using NHibernate.Cfg;
using NHibernate.Tool.hbm2ddl;
namespace NhibernateSample1
{
public class UserFixure
{
private ISession session;
public UserFixure()
{
}
/**//// <summary>
/// 创建表
/// </summary> 
public bool ExportTable()
{
try
{
Configuration cfg = new Configuration().Configure(@"E:\my project\nhibernate study\simle 1\NHibernateStudy1\NhibernateSample1\hibernate.cfg.xml");
session = NHibernateHelper.GetCurrentSession();
ITransaction transaction = session.BeginTransaction();
new SchemaExport(cfg).Create(true, true);
transaction.Commit();
return true;
}
catch(Exception ex)
{
throw ex;
}
finally
{
session.Close();
}
}
/**//// <summary>
/// 添加
/// </summary> 
public int Add()
{
try
{
User u = new User();
u.Name = Guid.NewGuid().ToString();
u.Pwd = "124";
session = NHibernateHelper.GetCurrentSession();
ITransaction transaction = session.BeginTransaction();
session.Save(u);
transaction.Commit();
return u.Id;
}
catch (Exception ex)
{
throw ex;
}
finally
{
session.Close();
}
}
/**//// <summary>
/// 更新
/// </summary>
/// <param name="uid"></param> 
public bool Update(int uid)
{
try
{
session = NHibernateHelper.GetCurrentSession();
ITransaction transaction = session.BeginTransaction();
User u = session.Load(typeof(User), uid) as User;
if (u != null)
{
u.Name = "updatedName";
session.SaveOrUpdate(u);
transaction.Commit();
u = session.Load(typeof(User), uid) as User;
if (u.Name == "updatedName")
{
return true;
}
}
return false;
}
catch (Exception ex)
{
throw ex;
}
finally
{
session.Close();
}
}
/**//// <summary>
/// 删除
/// </summary>
/// <param name="uid"></param>
/// <returns></returns> 
public bool Delete(int uid)
{
try
{
session = NHibernateHelper.GetCurrentSession();
ITransaction transaction = session.BeginTransaction();
User u = session.Get(typeof(User), uid) as User;
if (u != null)
{
session.Delete(u);
transaction.Commit();
u = session.Get(typeof(User), uid) as User;
if (u == null)
{
return true;
}
}
return false;
}
catch (Exception ex)
{
throw ex;
}
finally
{
session.Close();
}
}
public System.Collections.IList Query()
{
try
{
session = NHibernateHelper.GetCurrentSession();
ITransaction transaction = session.BeginTransaction();
System.Collections.IList list= session.CreateQuery("select u from User as u").List();
transaction.Commit();
return list;
}
catch (Exception ex)
{
throw ex;
}
finally
{
session.Close();
}
}
}
} 

using System;
using System.Text;
using System.Collections.Generic;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using NhibernateSample1;
namespace TestProject1
{
/**//// <summary>
/// UnitTest1 的摘要说明
/// </summary> 
[TestClass]
public class UnitTest1
{
public UnitTest1()
{
//
// TODO: 在此处添加构造函数逻辑
// 
}
其他测试属性#region 其他测试属性 
//
// 您可以在编写测试时使用下列其他属性:
//
// 在运行类中的第一个测试之前使用 ClassInitialize 运行代码
// [ClassInitialize()]
// public static void MyClassInitialize(TestContext testContext) { }
//
// 在类中的所有测试都已运行之后使用 ClassCleanup 运行代码
// [ClassCleanup()]
// public static void MyClassCleanup() { }
//
// 在运行每个测试之前使用 TestInitialize 运行代码
// [TestInitialize()]
// public void MyTestInitialize() { }
//
// 在运行每个测试之后使用 TestCleanup 运行代码
// [TestCleanup()]
// public void MyTestCleanup() { }
// 
#endregion 
int uid;
[TestMethod]
public void TestMethod1()
{
UserFixure userFixure = new UserFixure();
Assert.IsTrue(userFixure.ExportTable());
}
[TestMethod]
public void TestMethod2()
{
UserFixure userFixure = new UserFixure();
uid = userFixure.Add();
Assert.IsTrue(uid>0);
}
[TestMethod]
public void TestMethod3()
{
UserFixure userFixure = new UserFixure();
Assert.IsTrue(userFixure.Update(uid));
}
[TestMethod]
public void TestMethod4()
{
UserFixure userFixure = new UserFixure();
Assert.IsTrue(userFixure.Delete(uid));
}
[TestMethod]
public void TestMethod5()
{
UserFixure userFixure = new UserFixure();
Assert.IsTrue(userFixure.Query().Count>0);
}
}
}