Devart Forums

Hello!

There is the simple code fragment:

var query =
from a in Context.CUSTOMER
orderby a.INTCODE
select a.INTCODE;

foreach (var item in query.Take(10))
System.Diagnostics.Debug.WriteLine(item);

wich translate to following uncorrect SQL:
SELECT
"Extent1".INTCODE AS INTCODE
FROM PXBANK.CUSTOMER "Extent1"
WHERE ROWNUM <= (10)
ORDER BY "Extent1".INTCODE ASC
This sql doesn't really get first ten records (ROWNUM statement applied before any sortings).

dotConnect for Oracle 5.25.39

Thank you for the report.
I have reproduced the problem with our Entity Framework support (not LINQ to Oracle,
the problem is not reproducible using our LINQ to Oracle implementation).
I will let you know about the results of our investigation.

We have fixed the problem. The fix will be included in the next build of dotConnect for Oracle.