NHibernate Stored Procedure return columns mapping to entity properties

Skip to first unread message

Kumar Jalli

Sep 12, 2013, 10:32:04 AM9/12/13
to nh...@googlegroups.com
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 
columns are 
EmpId int,
EmpName nvarchar(50),
Salary money
and the procedure is

create procedure sp_EmployeeDetails
@EmpId as int
Select * from EmployeeDetails where EmpId=@EmpId
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)}
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....
Reply all
Reply to author
0 new messages