Get the return value from a StoredProc by using NHibernateH

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
tinaz1818
Ensign (ENS)
Ensign (ENS)
Posts: 15
Joined: Fri Aug 07, 2009 11:57 am

Get the return value from a StoredProc by using NHibernateH

Post by tinaz1818 » Tue Jan 03, 2017 10:56 am

I have a stored proc where I have a output parameter as a return value.

I use
ISQLQuery query = NHibernateHelper.CreateSQLQuery("exec StoredProcName");
query.SetParameter("BasketId", _Basket.Id);
query.SetParameter("ProductName", AddProductName.Text.Trim().ToString());
query.SetParameter("Price", Convert.ToDecimal(AddProductVariablePrice.Text.Trim()));
query.SetParameter("Quantity", Convert.ToInt16(AddProductQuantity.Text.Trim()));
query.SetParameter("rtn", 32); /*where rtn is a output parameter*/

query.ExecuteUpdate();



Then how can I get the return value of @rtn from it.

Post Reply