Metodo DataServiceQuery<TElement>.IncludeTotalCount
Richiede che il conteggio di tutte le entità nel set di entità venga restituito inline con i risultati della query.
Spazio dei nomi System.Data.Services.Client
Assembly: Microsoft.Data.Services.Client (in Microsoft.Data.Services.Client.dll)
Sintassi
'Dichiarazione
Public Function IncludeTotalCount As DataServiceQuery(Of TElement)
'Utilizzo
Dim instance As DataServiceQuery
Dim returnValue As DataServiceQuery(Of TElement)
returnValue = instance.IncludeTotalCount()
public DataServiceQuery<TElement> IncludeTotalCount()
public:
DataServiceQuery<TElement>^ IncludeTotalCount()
member IncludeTotalCount : unit -> DataServiceQuery<'TElement>
public function IncludeTotalCount() : DataServiceQuery<TElement>
Valore restituito
Tipo: System.Data.Services.Client.DataServiceQuery<TElement>
Nuovo oggetto DataServiceQuery<TElement> che dispone del set di opzioni di conteggio inline.
Osservazioni
La chiamata del metodo IncludeTotalCount equivale all'inclusione dell'opzione query $inlinecount nell'URI della query.
Esempi
In questo esempio viene eseguita una query dopo la chiamata del metodo IncludeTotalCount. È possibile utilizzare la proprietà TotalCount per determinare il numero di entità restituite dalla query.
' 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
// 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);
}