How do you do projections while you do paging?

Apr 1, 2015 at 9:49 PM
Using the Service pattern, how do you both project fewer fields and page? For example, this fails:
var query = _Service
     .Query( x => x.type == "company")
     .OrderBy( x => x.OrderBy( y => y.name)
     .Select( s => new DDL
          { text = s.name, id = s.id })
     .SelectPage( 2, 10, out totalCount);
The .SelectPage() produces an IEnumerable which grabs all the entity's fields, so we .Select() first to limit our fields to id and name, but then how would you select the second page of 10 records?
Coordinator
May 12, 2015 at 6:47 PM
Marked as answer by lelong37 on 5/12/2015 at 10:47 AM
Feb 13, 2016 at 6:14 PM
Are you able to accomplish this ?

Can you please provide me an example like how to do this ?