NHibernate Stored Procedure return columns mapping to entity properties

[Kumar Jalli]

Hi,
 
i want sample code to map the stored procedure return columns with the entity properties
 
suppose i have an entity class 
 

Public Class Employee
 
public Property EmployeeId as Integer
public Property EmployeeName as string
public Property Salary as double
 
End Class
 

 
and the stored procedure in sql server
 
suppose table is 
EmployeeDetails 
 
columns are 
EmpId int,
EmpName nvarchar(50),
Salary money
 
and the procedure is
 

 
create procedure sp_EmployeeDetails
@EmpId as int
as
begin
 
Select * from EmployeeDetails where EmpId=@EmpId
 
end
 

 
so the class properties and the procedure return columns are not same how to map this using fluent in vb.code
 

actually we are mapping the columns but both class properties and the procedure return columns are same using hbm.xml
 

 

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
  assembly="MyApplication" namespace="MyApplication">
 
  <sql-query name="GetEmployeeDetails" callable="true">
 

    <!-- Parameters -->
    <query-param name="EmpId" type="string"/>
 

    <!--Return values-->
    <return-scalar column="EmpId" type="integer"/>
    <return-scalar column="EmpName" type="string"/>
    <return-scalar column="Salary" type="double"/>
 
    {  execute sp_EmployeeDetails(@EmpId)}
 
  </sql-query>
</hibernate-mapping>
 

 
it is possible to get the data if the entity properties are EmpId,EmpName,Salary
 
and how can we get the stored procedure output parameter value
 
please help....
 
Thanks in advance....