You could use the first approach “Standard OpenAccessLinqDataSource with dynamic ‘where’ in code”. In this case the OpenAccessLinqDataSource paging, sorting and filtering will be executed on the server, when the data source is used from RadGrid for instance, the corresponding paging, sorting or filtering clauses will be handled internally, without implementing additional logic.
For case 2 and 3 – you should handle the paging manually, by implementing additional handling for it.
Additional helpful information can be found here
. You could find the OpenAccessLinqDataSource example, shipped with the Product SDK
Hope that helps. If any other questions arise, do not hesitate to contact us back.
the Telerik team