2
Vote

Data paging doesn't work

description

While the resulting EF model seems to work very nicely with the WCF RIA beta (that is after using EDMGEN2 to produce an .EDMX), in that type of usage scenario data paging is critical.
 
All of the open source Oracle EF providers appear to have the same problem in that the Order By clause is getting tacked on AFTER the requested rows have been retrieved. Oracle paging appears to only sort properly if the sql is constructed something like this:
 
select * from (select pgsrc.*, rownum rx from (select * from employees ORDER BY last,first) pgsrc where rownum<10000) where rx>9000

comments