Hi,
I am kind of new with nHibernate objects. I am using it with my Tables but now for first time I have to use it with my Stored Procedure. I tried creating class but I am getting some errors while calling this SQL Server Stored Procedure through hibernate object.
So can someone please provide me the class file and .hbm.xml file for this stored procedure ?
Will appreciate if someone can give me code for both the files as per this Stored Procedure.
( Out of 15 returning columns, last 5 columns are Varchar and rest are int )
#########################################

ALTER PROCEDURE [dbo].[RulesDetails_Get]
(
@ELAID INT ,
@FamilyID INT ,
@GroupID INT ,
@SubGroupID INT ,
@ItemComponentID INT ,
@ComponentID INT
)
AS
BEGIN

SELECT
QtyAlreadyOrdered_Component,
QtyAlreadyOrdered_Family,
QtyAlreadyOrdered_Group ,
QtyAlreadyOrdered_SubGroup,
QtyAlreadyOrdered_ELA ,

MaxQtyAllowed_Component ,
MaxQtyAllowed_Family ,
MaxQtyAllowed_Group ,
MaxQtyAllowed_SubGroup ,
MaxQtyAllowed_ELA ,

QtyBalanceAvailable_Component,
QtyBalanceAvailable_Family,
QtyBalanceAvailable_Group,
QtyBalanceAvailable_SubGroup,
QtyBalanceAvailable_ELA
FROM
MyTable1
WHERE
ELAID = @ELAID
AND
FamilyID = @FamilyID



#########################################