DataServiceQuery<TElement>.IncludeTotalCount Method ()


The .NET API Reference documentation has a new home. Visit the .NET API Browser on to see the new experience.

Requests that the count of all entities in the entity set be returned inline with the query results.

Namespace:   System.Data.Services.Client
Assembly:  System.Data.Services.Client (in System.Data.Services.Client.dll)

public DataServiceQuery<TElement> IncludeTotalCount()

Return Value

Type: System.Data.Services.Client.DataServiceQuery<TElement>

A new DataServiceQuery<TElement> object that has the inline count option set.

Calling the IncludeTotalCount method is equivalent to including the $inlinecount query option in the query URI.

This example executes a query after it calls the IncludeTotalCount method. The TotalCount property is used to determine number of entities returned by the query.

// Create the DataServiceContext using the service URI.
NorthwindEntities context = new NorthwindEntities(svcUri);

// Define a new query for Customers that includes the total count.
DataServiceQuery<Customer> query = context.Customers.IncludeTotalCount();

    // Execute the query for all customers and get the response object.
    QueryOperationResponse<Customer> response = 
        query.Execute() as QueryOperationResponse<Customer>;

    // Retrieve the total count from the response.
    Console.WriteLine("There are a total of {0} customers.", response.TotalCount);

    // Enumerate the customers in the response.
    foreach (Customer customer in response)
        Console.WriteLine("\tCustomer Name: {0}", customer.CompanyName);
catch (DataServiceQueryException ex)
    throw new ApplicationException(
        "An error occurred during query execution.", ex);

.NET Framework
Available since 3.5
Available since 4.0
Return to top