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