I know that not all of the database engines supported by Linq offer skip support, but it would be really helpful to have this functionality out of the box for engines like MS SQL Server. Take is already supported, and it isn't optimal to use the page selector component because that involves enumerating all the IDs in the table.
This may be a rather daunting task because you would have to add Skip support to the underlying XPO layer - but maybe, just maybe, you can do it? I know a lot of people have been asking around!
- Add support for Skip on Linq query objects.
- Perhaps add application-tier support for Skip in XPO for database engines that don't support Skip. A relevant property could be added to XPCollection, too!
Is your intention to post an answer to your own question?
- If so, then proceed.
- If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
- If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.