locked
How to call stored procedure PostgreSQL using Nhibernate ? RRS feed

  • Question

  • User726040161 posted

    Hello,

    I want to use the same StoredProcedure(create in sql server) in PostgreSQL.

    How to call Stored Procedure (PostgreSQL) type return "table" using Nhibernate ??

    NB : using SQL Server in User.hbm.xml = Exec GetUsers: title

    in DAO : 

    Ilist<User> GetUsers()
    {
    
    IQuery query = Session.GetNamedQuery("GetUsers"); 
    query.SetParameter("title", title); 
    IList<User> result = query.List(); 
    return result;
    
    }

     thanks

    Monday, March 18, 2013 3:33 PM

Answers