I'm using Fluent Nhibernate through Sharp Architecture.
I have a query that I am running that has been written in Native SQL and is executed using:
Code:
this.Session.CreateSQLQuery(query).AddEntity("Customer", typeof(App.Core.Customer)).List<Customer>();
The query completes successfully on within SQL Server 2008 but when it returns I get the exception: Nhibernate.ADO could not execute query (then the sql statement).
The Inner exception says: "SenderFi7_1_0_"
I have been able to run this directly in SQL server where it returns around 350,000 rows.
I have also been able to run the code against SQLite without getting the exception, but there was far less data to be returned.
Code:
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
at NHibernate.Impl.SessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters)
at NHibernate.Impl.SqlQueryImpl.List[T]()
at App.Data.CustomerRepository.FindByTriggerCriteria(Criteria triggerCriteria) in C:\App\Trunk\app\App.Data\CustomerRepository.cs:line 175
Any ideas?
Login
FAQ
Search