Oracle 11g using ODA.NET. App is in .Net 7.
After upgrading to 5.10.2 this code now throws and exception. I've tried to upgrade to 5.11.0 and hotfix 5.11.1 with the same result.
The code
LinqMetaData mData = new LinqMetaData(AdapterProvider.Current.Adapter);
IQueryable<GaChildobsPartMeasurementEntity> part =
(from p in mData.GaChildobsPartMeasurement
where p.PartId == criteria.PartId
select p);
if (part.Count() == 1)
part.Count() throws an ORA-00933 exception.
This code worked in previous versions of LLBLGen (ie. 5.8.8 and earlier)
The SQL generated (as shown in the exception) seems to be:
SELECT COUNT(*) AS LPAV_ FROM SAGA.GA_CHILDOBS_PART_MEASUREMENT LPLA_1 WHERE LPLA_1.PART_ID = '1AEF' FETCH NEXT 1 ROWS ONLY;
if I drop the FETCH NEXT part when running this SQL it runs fine in an SQL editor against the database.
Part of the StackTrace
SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException
HResult=0x80131500
Message=An exception was caught during the execution of a retrieval query: ORA-00933: SQL command not properly ended. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.
Source=SD.LLBLGen.Pro.ORMSupportClasses
StackTrace:
at SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterCore.FetchDataReader(IRetrievalQuery queryToExecute, CommandBehavior readerBehavior)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterCore.FetchProjection(List`1 valueProjectors, IGeneralDataProjector projector, IRetrievalQuery queryToExecute, Boolean performValueProjectionsOnRawRow, Boolean postProcessDBNullValues, Dictionary`2 typeConvertersToRun)
Any ideas as to what the issue could be?
