DataServiceQuery<TElement>.IncludeTotalCount Metode

Definisi

Ruang nama:

System.Data.Services.Client

Rakitan:

System.Data.Services.Client.dll

Meminta agar jumlah semua entitas dalam kumpulan entitas dikembalikan sebaris dengan hasil kueri.

public:
 System::Data::Services::Client::DataServiceQuery<TElement> ^ IncludeTotalCount();

public System.Data.Services.Client.DataServiceQuery<TElement> IncludeTotalCount ();

member this.IncludeTotalCount : unit -> System.Data.Services.Client.DataServiceQuery<'Element>

Public Function IncludeTotalCount () As DataServiceQuery(Of TElement)

Mengembalikan

DataServiceQuery<TElement>

Objek baru DataServiceQuery<TElement> yang memiliki kumpulan opsi jumlah sebaris.

Contoh

Contoh ini menjalankan kueri setelah memanggil IncludeTotalCount metode . Properti TotalCount digunakan untuk menentukan jumlah entitas yang dikembalikan oleh kueri.

// 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();

try
{
    // 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);
}

' Create the DataServiceContext using the service URI.
Dim context = New NorthwindEntities(svcUri)

' Define a new query for Customers that includes the total count.
Dim query As DataServiceQuery(Of Customer) = _
context.Customers.IncludeTotalCount()

Try
    ' Execute the query for all customers and get the response object.
    Dim response As QueryOperationResponse(Of Customer) = _
        CType(query.Execute(), QueryOperationResponse(Of 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.
    For Each customer As Customer In response
        Console.WriteLine(vbTab & "Customer Name: {0}", customer.CompanyName)
    Next
Catch ex As DataServiceQueryException
    Throw New ApplicationException( _
            "An error occurred during query execution.", ex)
End Try

Keterangan

Memanggil IncludeTotalCount metode setara dengan menyertakan $inlinecount opsi kueri di URI kueri.