I'm using SubSonic 2.2 with Oracle 9.2 and .NET 2.0.
I'm seeing an issue where SubSonic does not insert WHERE or ORDER BY clauses in the pagination SQL it generates for queries created with the SqlQuery object. I've looked at the source and the method responsible (OracleGenerator.BuildPagedSelectStatement) seems incomplete: The WHERE and ORDER BY clauses are generated, but are never merged into the final string that the method returns.
I'm using SubSonic 2.2 with Oracle 9.2 and .NET 2.0.
I'm seeing an issue where SubSonic does not insert WHERE or ORDER BY clauses in the pagination SQL it generates for queries created with the SqlQuery object. I've looked at the source and the method responsible (OracleGenerator.BuildPagedSelectStatement) seems incomplete: The WHERE and ORDER BY clauses are generated, but are never merged into the final string that the method returns.
Examples can be found here: http://stackoverflow.com/questions/3824483/how-does-one-do-an-oracle-top-n-paged-query-in-subsonic-2-2/