Hi,
I have following query :
var qry = context.patients.where(p=> X || Y); ( X and Y are some conditions ).
I want the query to return the first 51 rows,
so i return :
return qry.Take(51).ToList();
but the result is some 27000 records, because the generated sql is :
select ... from patientens where X or Y and rownum <= 51
instead of
select ... from patientens where (X or Y) and rownum <= 51
this does not seem correct behaviour to me .
greetings
Stijn
problem with Take on Query
The new build of dotConnect for Oracle 6.10.135 is available for download now. This build fixes the problem.
It can be downloaded from Download Page (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to this post.
It can be downloaded from Download Page (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to this post.