Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to force Skip(x).Take(y) to use bind variables in generated SQL

1035322Aug 23 2013

In the following sample code:

return query.Skip(X).Take(Y);

the generated SQL will have X and Y in the query as constants rather than bind variables.

For example: "ROWNUM <= (50)" instead of "ROWNUM <= (:p__linq__1)"

This makes optimizing oracle for the page that uses the query much more difficult.

Is there a way to get the generated SQL to use bind variables for the paging?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2013
Added on Aug 23 2013
0 comments
552 views