This may not the most efficient way to call stored procedure form Nhibernate using projects. But in my situation it first .In general when we uses Nhibrnate there is almost no need to use. In my case I am mapping my application with Legacy Database so i need sometimes to call Stored Procedures from Nhibernate (though iI am trying my best to avoid this )..
So here is the simple way to use it pretty quickly :
1. Here is my Stored procedure