Suppose I have a many-to-one relationship and a Ilist of child objects implemented in my class definition and I use a stored procedure to get all the objects of this class using the IQuery object's List method. Will Nhibernate still load the relationships also for me or is it not possible at this moment.

I am getting an error which says. IndexOutOfRangeException: Last4_5_0_]

I am attaching a copy of the hbm file for future references.



====================================================================================
====================================================================================
Error Stack Trace

[IndexOutOfRangeException: Last4_5_0_]
System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +4841826
System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +67
NHibernate.Driver.NHybridDataReader.GetOrdinal(String name) +40
NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name) +74
NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String[] names, ISessionImplementor session, Object owner) +56
NHibernate.Type.ManyToOneType.Hydrate(IDataReader rs, String[] names, ISessionImplementor session, Object owner) +83
NHibernate.Persister.Entity.AbstractEntityPersister.Hydrate(IDataReader rs, Object id, Object obj, ILoadable rootLoadable, String[][] suffixedPropertyColumns, Boolean allProperties, ISessionImplementor session) +1209
NHibernate.Loader.Loader.LoadFromResultSet(IDataReader rs, Int32 i, Object obj, String instanceClass, EntityKey key, String rowIdAlias, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session) +451
NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, String rowIdAlias, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session) +264
NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session) +480
NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies) +409
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +1287
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +106
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +172

[ADOException: could not execute query
[ exec [App_Products_Get] @p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15 ]
Name:Id - Value:null Name:Date_Of_Creation - Value:null Name:Date_Of_Modification - Value:null Name:Last_Modified_By - Value:null Name:Last_Session_Id - Value:null Name:Name - Value:null Name:Description - Value:null Name:Image_Location_Large - Value:null Name:Image_Location_Medium - Value:null Name:Image_Location_Thumbnail - Value:null Name:Is_Active - Value:1 Name:Date_Of_Creation_Begin - Value:null Name:Date_Of_Creation_End - Value:null Name:Date_Of_Modification_Begin - Value:null Name:Date_Of_Modification_End - Value:null Name:ProductCategory_Id - Value:null
[SQL: exec [App_Products_Get] @p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +336
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +46
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +155
NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) +52
NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) +259
NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) +232
NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) +229
NHibernate.Impl.SqlQueryImpl.List() +243
DAC.Datafetcher.GetAllProductsSearchResult(Decimal Id, DateTime Date_Of_Creation, DateTime Date_Of_Modification, Decimal Last_Modified_By, Decimal Last_Session_Id, String Name, String Description, String Image_Location_Large, String Image_Location_Medium, String Image_Location_Thumbnail, Boolean Is_Active, DateTime Date_Of_Creation_Begin, DateTime Date_Of_Creation_End, DateTime Date_Of_Modification_Begin, DateTime Date_Of_Modification_End, Decimal ProductCategory_Id) in E:\Development\Source Codes\ECommerce\Persistence\Datafetcher.cs:169
Products.Bind_Grid() in e:\Development\Source Codes\ECommerce\Products.aspx.cs:23
Products.Page_Load(Object sender, EventArgs e) in e:\Development\Source Codes\ECommerce\Products.aspx.cs:74
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

I can confirm the same problem. It appears to only happen with a stored procedure (sproc) result set is mapped to a return class. In-line SQL mapped to a return class works absolutely fine.

Relevant part of my mapping file:




Class definition:



Example result set:



Relevant stack trace:




This was a real headache to debug. I moved my sproc into a table-valued function in SQL 2008, and then made the SQL "in-line" like this, thinking the problem was with the SPROC engine.



That didn't do a darn thing, the error was the same -- it kept mangling the column alias and then was still unable to find it via GetOrdinal.

The fix was, surprisingly simple: I simply stopped using "return class" and started using "return alias", which reduced my mapping to this:



Worked like a charm then. I'm not sure what's wrong about specifying return-properties for a "return class" -- a number of examples on the web show it done this way... but it would appear Nhibnerate then attempts to look up columns by the names you specified, not by the names it decided to mangle the column aliases as.

Happy coding!