I use the following snippet in mapping file and execute SQL Server stored procedure, my app works well

<sql-query name="test">
<return-scalar type="Date" column="Date"></return-scalar>
exec getDate :userID
</sql-query>

When I want to get a list of data from SQL server with the following mapping file :

<sql-query name="test">
<return class="test" alias="t">
<return-property name="Date" column="Date"></return-property>
</return>
exec getDate :userID
</sql-query>

I got problem :
System.IndexOutOfRangeException :

Error... Tablename_1_0_0 .......

Please tell me How I can get the list of data from executing stored procedure in NHibernate.

Thanks in advance.

Regards,

pcphuc.

Hi,

Couple of things:

1.) Make sure you have that column/property defined in your table(result set)/entity.
2.) Make sure the returned results columns are mapped 1:1 with your entity since your named-query returns the entity itself.

Either of those will produce the exception since Nh's engine won't have a way to map the result to your entity.

hth