How to call stored procedure PostgreSQL using Nhibernate ? RRS feed

  • Question

  • User726040161 posted


    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;


    Monday, March 18, 2013 3:33 PM