Entity Framework Plus Query Future - Paging Scenario
The first ten posts must be returned but you also need to know the total numbers of posts
// using Z.EntityFramework.Plus; // Don't forget to include this. var ctx = new EntitiesContext(); var futurePost = ctx.Posts.OrderBy(x => x.CreatedDate).Take(10).Future() var futurePostCount = ctx.Post.DeferredCount().FutureValue(); // ONE database round trip is required var post = futurePost.ToList(); var postCount = futurePostCount.Value;