NHibernate Stored Procedure return columns mapping to entity properties

9 views
Skip to first unread message

Kumar Jalli

unread,
Sep 12, 2013, 10:32:04 AM9/12/13
to nh...@googlegroups.com
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....
Reply all
Reply to author
Forward
0 new messages