I want to fetch only first n records from a Query.
I can use such a query:
SELECT * FROM (
)
WHERE ROWNUM <= n,
but there are some limitations.
So is there MaxRecords option in ODAC?
Something like MaxRecords property in ADO.
Is there MaxRecords option in ODAC?
There is no such functionality in ODAC, but you can see http://crlab.com/forums/viewtopic.php?p=1301#1301 topic it may be intresting for you.