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 Integerpublic Property EmployeeName as
stringpublic 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 intasbegin
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....
--
---
You received this message because you are subscribed to the Google Groups
"nhibernate-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
