Hi,
generally this group is not a good place to post such messages. I recommend
to use NH users group.
Besides you can use a google ie:
http://elegantcode.com/2008/11/23/populating-entities-from-stored-procedures-with-nhibernate/
or
http://stackoverflow.com/questions/14750969/is-it-possible-to-call-a-stored-procedure-using-nhibernate-which-returns-a-custo
W dniu czwartek, 12 września 2013 16:16:56 UTC+2 użytkownik Kumar Jalli
napisał:
>
> 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.
