配置ASP.NET Nhibernate

web.config:配置sql server数据库

<configuration>
    <configSections>
        <!--NHibernate Section-->
        <section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler,NHibernate"/>
        <!--NHibernate Section End-->
    </configSections>
    <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
        <session-factory name="NHibernate.Test">
            <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
            <property name="connection.connection_string">
                server=127.0.0.1;database=NHibernateSample;uid=sa;pwd=zhangwei
            </property>
            <property name="adonet.batch_size">10</property>
            <property name="show_sql">true</property>
            <property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>
            <property name="use_outer_join">true</property>
            <property name="command_timeout">60</property>
            <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
            <property name="proxyfactory.factory_class">
                NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu
            </property>
        </session-factory>
    </hibernate-configuration>
......

web.config:配置 Oracle 数据库

<configuration>
    <configSections>
        <!--NHibernate Section-->
        <section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler,NHibernate"/>
        <!--NHibernate Section End-->
    </configSections>
    <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
        <session-factory>
            <property name="connection.provider">
                NHibernate.Connection.DriverConnectionProvider
            </property>
            <property name="connection.driver_class">
                NHibernate.Driver.OracleClientDriver
            </property>
            <property name="dialect">
                NHibernate.Dialect.Oracle10gDialect
            </property>
            <property name="connection.connection_string">
                Data Source=155ZNXJ;User ID=cxm;Password=cxm
            </property>
            <property name="proxyfactory.factory_class">
                NHibernate.ByteCode.LinFu.ProxyFactoryFactory,
                NHibernate.ByteCode.LinFu
            </property>
            <property name="show_sql">true</property>
            <property name="query.substitutions">
                true 1, false 0, yes 'Y', no 'N'
            </property>
        </session-factory>
    </hibernate-configuration>
......

 

SessionFactory:

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using NHibernate;
using NHibernate.Cfg;

namespace MyMvcDemo.Nhibernate
{
    public class SessionFactory
    {
        private ISessionFactory _sessionFactory;

        public SessionFactory()
        {
            _sessionFactory = GetSessionFactory();
        }

        private void Init()
        {
            var config = new Configuration();
            config.AddAssembly("MyMvcDemo.Nhibernate");
            config.Configure();
            _sessionFactory = config.BuildSessionFactory();
        }

        private ISessionFactory GetSessionFactory()
        {
            if (_sessionFactory == null)
                Init();

            return _sessionFactory;
        }

        public ISession GetSession()
        {
            return _sessionFactory.OpenSession();
        }
    }
}

Customer.hbm.xml:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="MyMvcDemo.Model" namespace="MyMvcDemo.Model.Customer">
    <class name ="Customer" table="Customer" lazy="false">
        <id name="CustomerId">
            <generator class ="native"/>
        </id>

        <property name="FirstName"/>
        <property name ="LastName"/>
    </class>
</hibernate-mapping>

Customer.cs

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

namespace MyMvcDemo.Model.Customer
{
    public class Customer
    {
        public int CustomerId { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string Version { get; set; }
    }
}

HomeController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web.Mvc;
using NHibernate;
using NHibernate.Cfg;
using MyMvcDemo.Service;
using MyMvcDemo.Nhibernate;

namespace MyMvcDemo.Controllers
{
    public class HomeController : Controller
    {
        private readonly ISession _session;
        readonly SessionFactory _sessionFactory = new SessionFactory();
        private readonly CustomerService _customerService;

        public HomeController()
        {
            _session = _sessionFactory.GetSession();
            _customerService = new CustomerService(_session);
        }


        public ActionResult Index()
        {
            var customer = _customerService.GetCustomerById(1);
            ViewData["Message"] = customer.FirstName + customer.LastName;
            return View();
        }

        public ActionResult About()
        {
            ViewData["Message"] = "Hello About";
            return View();
        }
    }
}

CustomerService.cs:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using NHibernate.Cfg;
using NHibernate;
using MyMvcDemo.Nhibernate;
using MyMvcDemo.Model.Customer;
using MyMvcDemo.Service;
using NHibernate.Criterion;

namespace MyMvcDemo.Service
{
    public class CustomerService
    {
        private ISession _session;
        public ISession Session
        {
            set { _session = value; }
        }

        /// <summary>
        /// 初始化Session
        /// </summary>
        /// <param name="session"></param>
        public CustomerService(ISession session)
        {
            _session = session;
        }

        /// <summary>
        /// 添加Customer
        /// </summary>
        /// <param name="customer"></param>
        public void CreateCustomer(Customer customer)
        {
            _session.Save(customer);
            _session.Flush();
        }

        /// <summary>
        /// 根据id获取Customer
        /// </summary>
        /// <param name="customerid"></param>
        /// <returns></returns>
        public Customer GetCustomerById(int customerid)
        {
            return _session.Get<Customer>(customerid);
        }

        public IList<Customer> GetCustomerByFirstName(string name)
        {
            return _session.CreateCriteria(typeof(Customer))
                           .Add(Restrictions.Eq("FirstName", name))
                           .List<Customer>();
        }
    }
}

Index.aspx:

<%@ Page Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage" %>

<asp:Content ID="Content1" ContentPlaceHolderID="TitleContent" runat="server">
    Home Page
</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <h2><%: ViewData["Message"] %></h2>
    <p>
        To learn more about ASP.NET MVC visit <a href="http://asp.net/mvc" title="ASP.NET MVC Website">http://asp.net/mvc</a>.
    </p>
</asp:Content>

运行结果：