지쏘니의 세상

            @Html.ActionLink("Edit", "Edit", new { id = item.ShipperID }) |

            @Html.ActionLink("Details", "Details", new { id = item.ShipperID }) |

            @Html.ActionLink("Delete", "Delete", new { id = item.ShipperID })

        public ActionResult Details(int id)

        {

            ISession session = SessionProvider.Instance.GetSession();

            Shippers shipper = session.Get<Shippers>(id);

            return View(shipper);

        }

        [HttpPost]

        public ActionResult Create(Shippers shipper)

        {

            ISession session = SessionProvider.Instance.GetSession();

            ITransaction trans = null;

            try

            {

                trans = session.BeginTransaction();

                session.Save(shipper);

                session.Flush();

                trans.Commit();

                return RedirectToAction("Index");

            }

            catch

            {

                trans.Rollback();

                return View();

            }

        }

        [HttpPost]

        public ActionResult Edit(Shippers shipper)

        {

            ISession session = SessionProvider.Instance.GetSession();

            ITransaction trans = null;

            try

            {

                trans = session.BeginTransaction();

                session.Merge(shipper);

                session.Flush();

                trans.Commit();

            }

            catch

            {

                trans.Rollback();

            }

            return RedirectToAction("Index");

        }

        public ActionResult Delete(int id)

        {

            ISession session = SessionProvider.Instance.GetSession();

            Shippers shipper = session.Get<Shippers>(id);

            ITransaction trans = null;

            try

            {

                trans = session.BeginTransaction();

                session.Delete(shipper);

                session.Flush();

                trans.Commit();

                return RedirectToAction("Index");

            }

            catch

            {

                trans.Rollback();

                return View();

            }

        }

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using NHibernate;

using NHibernate.Cfg;

namespace NHibernateDemo

{

    public class SessionProvider

    {

        private ISession _session;

        private ISessionFactory _sessionFac;

        private bool _reuseSession;

        #region Thread-safe Singleton

        public static SessionProvider Instance

        {

            get

            {

                return Nested.TheSingleton;

            }

        }

        private SessionProvider()

        {

            // Read the configuration

            Configuration cfg = new Configuration();

            cfg.AddAssembly("NHibernateDemo");

            _sessionFac = cfg.BuildSessionFactory();

            _reuseSession = false;

        }

        private class Nested

        {

            static Nested() { }

            internal static readonly SessionProvider

                TheSingleton = new SessionProvider();

        }

        #endregion

        /// <summary>

        /// Should the session be reused? If

        /// this property is false (default), a Session-Per-Request

        /// is applied.

        /// </summary>

        public bool ReuseSession

        {

            get

            {

                return _reuseSession;

            }

            set

            {

                _reuseSession = value;

            }

        }

        /// <summary>

        /// Get the current session. If the session is null,

        /// Open a new Session

        /// </summary>

        /// <returns>ISession-Object</returns>

        public ISession GetSession()

        {

            if (_session == null)

                _session = _sessionFac.OpenSession();

            return _session;

        }

        /// <summary>

        /// Close a Session, if the flag ReuseSession is false

        /// </summary>

        public void CloseSession()

        {

            if (_session != null)

            {

                if (!_reuseSession)

                {

                    _session.Close();

                    _session = null;

                }

            }

        }

    }

}

        public ActionResult Index()

        {

            IList<Shippers> list = null;

            try

            {

                ISession session = SessionProvider.Instance.GetSession();

                NHibernate.ICriteria ctiq = session.CreateCriteria(typeof(Shippers));

                list = ctiq.List<Shippers>();

            }

            catch (Exception ex)

            {

                throw;

            }

            return View(list);

        }

  <configSections>

    <section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate"/>

  </configSections>

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

    <session-factory name="NHibernateDemo">

      <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>

      <property name="connection.connection_string">

        Data Source=JISEON-PC\JISEON2;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa;Password=P@ssw0rd;

      </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>

    public class Shippers

    {

        private int _shipperID;

        private string _companyName;

        private string _phone;

        public Shippers()

        {

        }

        public virtual int ShipperID

        {

            get { return _shipperID; }

            set { _shipperID = value; }

        }

        public virtual string CompanyName

        {

            get { return _companyName; }

            set { _companyName = value; }

        }

        public virtual string Phone

        {

            get { return _phone; }

            set { _phone = value; }

        }

    }

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

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="NHibernateDemo"assembly="NHibernateDemo">

  <class name="NHibernateDemo.Entities.Shippers" table="Shippers">

    <id name="ShipperID" column="ShipperID" type="Int32" unsaved-value="-1" access="field.camelcase-underscore">

      <generator class="identity" />

    </id>

    <property name="CompanyName" column="CompanyName" type="string" length="40" not-null="true"access="field.camelcase-underscore"/>

    <property name="Phone" column="Phone" type="string" length="24" access="field.camelcase-underscore"/>

  </class>

</hibernate-mapping>

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

<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=(local);initial catalog=nhibernate;Integrated Security=SSPI

                           </property>

                           <property name="adonet.batch_size">10</property>

                           <property name="show_sql">false</property>

                           <property name="dialect">NHibernate.Dialect.MsSql2000Dialect</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>

                           <propertyname="proxyfactory.factory_class">NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu</property>

             </session-factory>

</hibernate-configuration>   

<update id="UpdateShippers" parameterClass="Shippers">

        UPDATE [Shippers]

        SET CompanyName = #CompanyName#, Phone = #Phone#

        WHERE ShipperID = #ShipperID#

</update>

        private void btnUpdate_Click(object sender, EventArgs e)

        {

            try

            {

                Shippers shipper = new Shippers();

                shipper.ShipperID = 4;

                shipper.CompanyName = "SM Company";

                shipper.Phone = "(02)0000-4444";

                Mapper.Instance().Update("UpdateShippers", shipper);

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.ToString());

            }

        }

<insert id="InsertShippers" parameterClass="Shippers">

        INSERT INTO [Shippers](CompanyName, Phone)

        VALUES (#CompanyName#, #Phone#)

        <selectKey type="post" resultClass="int" property="ShipperID">

               select @@IDENTITY as value

        </selectKey>

</insert>

        private void btnInsert_Click(object sender, EventArgs e)

        {

            try

            {

                Shippers shipper = new Shippers();

                shipper.CompanyName = "JS Company";

                shipper.Phone = "(02)1212-4444";

                object obj = Mapper.Instance().Insert("InsertShippers", shipper);

                MessageBox.Show(obj.ToString());

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.ToString());

            }

        }

<delete id="DeleteShippers" parameterClass="Shippers">

        DELETE FROM [Shippers]

        WHERE ShipperID = #ShipperID#

</delete>

        private void btnDelete_Click(object sender, EventArgs e)

        {

            try

            {

                Shippers shipper = new Shippers();

                shipper.ShipperID = 4;

                Mapper.Instance().Delete("DeleteShippers", shipper);

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.ToString());

            }

        }

<provider name="OleDb1.1"

          description="OleDb, provider V1.0.5000.0 in framework .NET V1.1"

          enabled="true"

          assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

    connectionClass="System.Data.OleDb.OleDbConnection"

          commandClass="System.Data.OleDb.OleDbCommand"

          parameterClass="System.Data.OleDb.OleDbParameter"

          parameterDbTypeClass="System.Data.OleDb.OleDbType"

          parameterDbTypeProperty="OleDbType"

          dataAdapterClass="System.Data.OleDb.OleDbDataAdapter"

          commandBuilderClass="System.Data.OleDb.OleDbCommandBuilder"

          usePositionalParameters="true"

          useParameterPrefixInSql="false"

          useParameterPrefixInParameter="false"

          parameterPrefix=""

    allowMARS="false"   

    />

        <!-- Database connection information -->

        <database>

               <provider name="sqlServer2.0"/>

               <dataSource name="Northwind" connectionString="Data Source=JISEON;Initial Catalog=Northwind;Integrated Security=True;"/>

        </database>

    public class Shippers

    {

        public int ShipperID { get; set; }

        public string CompanyName { get; set; }

        public string Phone { get; set; }

    }

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

<sqlMap namespace="EF4._14" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://ibatis.apache.org/mapping">

        <alias>

               <typeAlias alias="Shippers"  type="EF4._14.Shippers" />

        </alias>

       <statements>

             <select id="SelectShippers"  resultClass="Shippers">

                    select * from Shippers

             </select>

       </statements>

</sqlMap>

using IBatisNet.Common;

using IBatisNet.DataMapper;

        private void btnSelect_Click(object sender, EventArgs e)

        {

            try

            {

                IList<Shippers> list = Mapper.Instance().QueryForList<Shippers>("SelectShippers", null);

                dataGridView1.DataSource = list;

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.ToString());

            }

        }

Provider

Provider Description

sqlServer1.0

Microsoft SQL Server 7.0/2000 provider available with .NET Framework 1.0

sqlServer1.1

Microsoft SQL Server 7.0/2000 provider available with .NET Framework 1.1

OleDb1.1

OleDb provider available with .NET Framework 1.1

Odbc1.1

Odbc provider available with .NET Framework 1.1

sqlServer2.0

Microsoft SQL Server 7.0/2000/2005 provider available with .NET Framework 2.0

OleDb2.0

OleDb provider available with .NET Framework 2.0

Odbc2.0

Odbc provider available with .NET Framework 2.0

oracle9.2

Oracle provider V9.2.0.401

oracle10.1

Oracle provider V10.1.0.301

oracleClient1.0

MS Oracle provider V1.0.5 available with .NET Framework 1.1

ByteFx

ByteFx MySQL provider V0.7.6.15073

MySql

MySQL provider V1.0.4.20163

SQLite3

SQLite.NET provider V0.21.1869.3794

Firebird1.7

Firebird SQL .NET provider V1.7.0.33200

PostgreSql0.7

Npgsql provider V0.7.0.0

iDb2.10

IBM DB2 iSeries provider V10.0.0.0