I have a stored procedure I am trying to map from sql server to Nhibernate. I have callable="true" and the error I am getting is:
The 'callable' attribute is not declared. An error occurred at , (12, 13).
It's when I assign my assembly to the Configuration object in this line:
Code:
Configuration cfg = new Configuration();
cfg.AddAssembly("EmployeeTimeTracker");
I am using NHibernate version 1.2, SQL Server 2005, .net 1.1 fmrwk.
It gets to my MngrEmps.hbm.xml file, and bombs. Here is the mapping:
Code:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="EmployeeTimeTracker.MngrEmps, EmployeeTimeTracker" table="EMPLOYEE">
<id name="EmpID" column="EMPLOYEEID" >
<generator class="assigned" />
</id>
<property name="MngrID" column="EMPLOYEEPARENTID" />
<loader query-ref="SP_GET_EMP_LIST" />
</class>
<sql-query name="SP_GET_EMP_LIST" callable="true">
<return class="EmployeeTimeTracker.MngrEmps, EmployeeTimeTracker">
<return-property name="MngrID" column="mgr_employee_id" />
<return-property name="EmpID" column="employee_id" />
</return>
exec SP_GET_EMP_LIST :empID
</sql-query>
</hibernate-mapping>
Please help. Thank you.