Use NHibernate CreateSQLQuery Method to add output parameter

See more:

SQL

.NET

NHibernate

, +

Guys, I am trying to connect with sql server using NHibernate from .net application.

Here's what I am trying to do.

var query = DataSession.Session.CreateSQLQuery("EXEC usp_test @Id=:Pid, @Name=:Name");
query.SetInt32("Pid",1);
query.SetParameter("Name","testname");
query.AddEntity(typeof(MyEntity));
var returnData = query.List<MyEntity>();

Now I am able to get the data successfully. The problem is that I want proc to send me some output values as well. So I have increased the output parameters in my proc. But don't know how to do that here in CreateSQLQuery Method.

I have already googled it, but they have implemented it using SqlCommand and all that, including SqlDataReader. I don't wanna do that.

Any help will be much appreciated.