我的第一个NHibernate示例

整个项目的结构图如下：

1、开发工具Microsoft Visual Studio2010、SQL Server2012

2、NHibernate版本为3.3.1

3、新建类库GaoJie.Domain，在该类库项目下新建两个文件夹Domain和Mapping。

编写Student类，该类在Domain文件夹下。代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace GaoJie.Domain.Domain
{
    /// <summary>
    /// Student
    /// </summary>
    public class Student
    {
        /// <summary>
        /// Id
        /// </summary>
        public virtual Guid Id { set; get; }

        /// <summary>
        /// Name
        /// </summary>
        public virtual string Name { set; get; }

        /// <summary>
        /// Age
        /// </summary>
        public virtual int Age { set; get; }
    }
}

 

编写映射文件Student.hbm.xml，将该文件的属性设置为，如图所示：

代码如下：

<?xml version="1.0" encoding="utf-8" ?>

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="GaoJie.Domain" namespace="GaoJie.Domain.Domain">

  <class name="Student" table="T_Student" lazy="true">

    <id name="Id" column="ID" type="Guid">
      <generator class="assigned"/>
    </id>

    <property name="Name" type="string">
      <column name="Name" length="50"/>
    </property>

    <property name="Age" type="int">
      <column name="Age"/>
    </property>

  </class>

</hibernate-mapping>

 

4、新建类库GaoJie.Lib，新建文件夹lib，里面有如下文件Iesi.Collections.dll、
NHibernate.dll、nunit.framework.dll

5、新建类库GaoJie.Dao，添加StudentDao类和IStudentDao接口。

StudentDao代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using GaoJie.Domain.Domain;
using NHibernate;
using NHibernate.Cfg;
using NHibernate.Linq;

namespace GaoJie.Dao
{
    public class StudentDao:IStudentDao
    {
        #region fields
        private ISession session;
        private ISessionFactory sessionFactory;
        #endregion

        #region Constructor
        public StudentDao()
        {
            var cfg = new Configuration().Configure("Config/hibernate.cfg.xml");

            using (sessionFactory = cfg.BuildSessionFactory())
            {
            }            
        }
        #endregion

        #region Method


        public object Save(Student student)
        {
            using (session = sessionFactory.OpenSession())
            {
                var id=session.Save(student);
                session.Flush();
                return id;
            }
        }

        public void Update(Student student)
        {
            using (session = sessionFactory.OpenSession())
            {
                session.Update(student);
                session.Flush();
            }               
        }

        public void Delete(Student student)
        {
            using (session = sessionFactory.OpenSession())
            {
                session.Delete(student);
                session.Flush();
            }
        }

        public Student Get(object id)
        {
            using (session = sessionFactory.OpenSession())
            {
                return session.Get<Student>(id);
            }
        }

        public IList<Student> GetAll()
        {
            using (session=sessionFactory.OpenSession())
            {
                return session.Query<Student>().ToList();
            }
        }

        private bool IsSessionOpen()
        {
            bool isSessionOpen = false;

            if (!session.IsOpen)
            {
                session = sessionFactory.OpenSession();
                isSessionOpen = true;
            }

            return isSessionOpen;
        }
        #endregion
    }
}

 

IStudentDao代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using GaoJie.Domain.Domain;

namespace GaoJie.Dao
{
    public interface IStudentDao
    {
        object Save(Student student);

        void Update(Student student);

        void Delete(Student student);

        Student Get(object id);

        IList<Student> GetAll();
    }
}

 

编写hibernate.cfg.xml：该文件在GaoJie.Dao类库下的Config文件夹下，设置该文件的属性，如图所示：

代码如下：

<?xml version="1.0" encoding="utf-8"?>

<hibernate-configuration  xmlns="urn:nhibernate-configuration-2.2" >

  <session-factory name="GaoJie.NHibernate.Domain">
    <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
    <property name="connection.connection_string">
      Server=(local);initial catalog=NHibernateDemo;Integrated Security=SSPI
    </property>
    <property name="adonet.batch_size">10</property>
    <property name="show_sql">true</property>
    <property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
    <property name="command_timeout">60</property>
    <property name="hbm2ddl.auto">update</property>
    <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
    <mapping assembly="GaoJie.Domain"/>
  </session-factory>

</hibernate-configuration>

 

6、新建类库GaoJie.Test，添加引用

Iesi.Collections.dll、
NHibernate.dll、nunit.framework.dll

新建StudentTest类，编写代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using GaoJie.Domain.Domain;
using NHibernate;
using NHibernate.Cfg;
using NUnit.Framework;
using GaoJie.Dao;
using GaoJie.Domain;


namespace GaoJie.Test
{
    [TestFixture]
    public class StudentTest
    {
        private IStudentDao studentDao; 

        [SetUp]
        public void Init()
        {
            studentDao=new StudentDao();
        }

        [Test]
        public void Save()
        {
            Student student=new Student()
                                {
                                    Id =Guid.NewGuid(),
                                    Name = "张三",
                                    Age = 22
                                };

            var id = studentDao.Save(student);

            Assert.NotNull(id);
        }

        [Test]
        public void Update()
        {
            int expected = 0;
            var student = studentDao.GetAll().FirstOrDefault();
            
            Assert.NotNull(student);

            student.Age = 43;
            expected = student.Age;

            studentDao.Update(student);

            Assert.AreEqual(expected,student.Age);
        }

        [Test]
        public void Delete()
        {
            var student = studentDao.GetAll().FirstOrDefault();
            var id = student.Id;
            Assert.NotNull(student);

            studentDao.Delete(student);
            Assert.Null(studentDao.Get(id));
        }

        [Test]
        public void Get()
        {
            var student = studentDao.GetAll().FirstOrDefault();
            Assert.NotNull(student);

            student=studentDao.Get(student.Id);
            Assert.NotNull(student);
        }

        [Test]
        public void GetAll()
        {
            var student = studentDao.GetAll().Count;
            Assert.NotNull(student>0);
        }
    }
}

 

测试结果如下：