nhibernate对存储过程的运用

using NHibernate.Engine;
using NHibernate;

namespace DataAccess
{
    public class UserAccess
    {
        public UserAccess()
        {
            cfg.AddAssembly("Entitys");
            //session = cfg.BuildSessionFactory().OpenSession();
        }

        private NHibernate.Cfg.Configuration cfg = new NHibernate.Cfg.Configuration();
        private ISession session = null;
        private ITransaction tran = null;

        /// <summary>
        /// NHibernate 调用存储过程
        /// </summary>
        /// <returns></returns>
        public ArrayList ExeProc()
        {
            ArrayList list = new ArrayList();
            ISessionFactoryImplementor imp = (ISessionFactoryImplementor)cfg.BuildSessionFactory();
            IDbConnection conn = imp.ConnectionProvider.GetConnection();
            IDbCommand cmd = imp.ConnectionProvider.GetConnection().CreateCommand();

            try
            {
                cmd.CommandText = "TestProc";  //存储过程名
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                IDbDataParameter parameter = cmd.CreateParameter();
                parameter.ParameterName = "id";  //需要的参数
                parameter.Value = 3;    //为参数赋值
                cmd.Parameters.Add(parameter); 
                cmd.Connection = conn;   //设置连接
                IDataReader read= cmd.ExecuteReader(); 
                while (read.Read())
                {
                    UserTest collection = new UserTest();
                    collection.age = read.GetValue(0).ToString();
                    collection.id = read.GetValue(1).ToString();
                    collection.LastTime = read.GetValue(2).ToString();
                    collection.TureName= read.GetValue(3).ToString();
                    list.Add(collection);
                }
            }
            catch (Exception ex)
            {
                this.m_error = ex.Message;
            }
            finally
            {
                imp.CloseConnection(conn);
            }
            return list;
        }

    }

-----------展现层调用------------

    protected void Button8_Click(object sender, EventArgs e)
    {
        list = UserTools.ExeProc();
        this.GridView1.DataSource = list;
        this.GridView1.DataBind();
        this.Label2.Text = UserTools.Error;
    }

--------------sql 存储过程创建方法--------------------

--创建存储过程
alter proc TestProc
(
@id int
)
as
(
 select * from login where id=@id
)

--测试存储过程
exec TestProc 3

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/xxj_jing/archive/2007/10/18/1831433.aspx

转载于:https://www.cnblogs.com/xusui/archive/2011/06/16/2082660.html