Проблема с NHibernate и stored procedure
От: Kide Украина  
Дата: 14.08.09 11:43
Оценка:
Добрый день!
Пытаюсь выполнить процедуру через nhibernate

            IQuery query = base.NHSession.CreateSQLQuery(@"exec Sp_GetAllNews ?", "News", typeof(News));
            query.SetParameter("stext", stext);

И при запуске получаю вот такую ошибку:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: id0_

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[IndexOutOfRangeException: id0_]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +4839010
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +67
   NHibernate.Driver.NHybridDataReader.GetOrdinal(String name) +13
   NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name) +47
   NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String[] names, ISessionImplementor session, Object owner) +27
   NHibernate.Loader.Loader.GetKeyFromResultSet(Int32 i, ILoadable persister, Object id, IDataReader rs, ISessionImplementor session) +68
   NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, IList hydratedObjects, Object optionalObject, Object optionalId, Key[] keys, Boolean returnProxies) +228
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Object optionalObject, Object optionalId, Object[] optionalCollectionKeys, Boolean returnProxies) +450
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Object optionalObject, Object optionalId, Object[] optionalCollectionKeys, Boolean returnProxies) +76
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +17
   NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) +205
   NHibernate.Loader.SqlLoader.List(ISessionImplementor session, QueryParameters queryParameters) +38
   NHibernate.Impl.SessionImpl.FindBySQL(String sqlQuery, String[] aliases, Type[] classes, QueryParameters queryParameters, ICollection querySpaces) +201

[ADOException: error in FindBySQL]
   NHibernate.Impl.SessionImpl.FindBySQL(String sqlQuery, String[] aliases, Type[] classes, QueryParameters queryParameters, ICollection querySpaces) +266
   NHibernate.Impl.SqlQueryImpl.List() +93
   Cuyahoga.Modules.StaticHtml.StaticHtmlModule.GetAllNews(String stext) in D:\kide\Cuyahoga\Modules\StaticHtml\StaticHtmlModule.cs:125

Подскажите из-за чего проблема и куда копать?
А то уже мысли останавливаются...
 
Подождите ...
Wait...
Пока на собственное сообщение не было ответов, его можно удалить.