EntityQueryPager Question

TotalDataSourceItemCount will return -1 until the last page is fetched via a call to MoveToLastPage.

TotalItemCount will return -1 until all pages are fetched or the TotalDataSourceItemCount is known.

While TotalDataSourceItemCount returns the count of records available to be returned from the datasource, TotalItemCount will also include items only present in the client.

If you want to retrieve the total item count before reaching the last page, you will need to query this value:

var totalCount = mgr.Employees.Count();

Regards,

   Silvio.

 

Got it, it works when the MoveToLastPage() is called but I'm just curious if this process is the same as loading all the records then you're paging it in the client side? Because if that's so, it will be a huge delay when concerning ten thousands of records.

 

I need to get the totaldatasource count in order to compute the pagecount (TotalDataSourceCount / PageSize).

I think it's better if you have a PageCount property as well as TotalDataSourceCount that doesn't need to call the MoveToLastPage() in order to get the count of the records from the datasource.

 

Thanks,

Von