TableQuery<TElement> TableQuery<TElement> TableQuery<TElement> Class

Definition

Represents a query against a Microsoft Azure table.

public class TableQuery<TElement> : System.Collections.Generic.IEnumerable<TElement>, System.Linq.IQueryable<TElement>
type TableQuery<'Element> = class
    interface IQueryable<'Element>
    interface seq<'Element>
    interface IQueryable
    interface IEnumerable
Public Class TableQuery(Of TElement)
Implements IEnumerable(Of TElement), IQueryable(Of TElement)

Type Parameters

TElement

A class which implements ITableEntity.

Inheritance
TableQuery<TElement>TableQuery<TElement>TableQuery<TElement>
Implements

Constructors

TableQuery<TElement>() TableQuery<TElement>() TableQuery<TElement>()

Initializes a new instance of the TableQuery<TElement> class.

Properties

ElementType ElementType ElementType

Gets the type of the element(s) that are returned when the expression tree is executed.

Expression Expression Expression

Gets the expression tree.

FilterString FilterString FilterString

Gets or sets the filter expression to use in the table query.

Provider Provider Provider

Gets the query provider that is associated with this data source.

SelectColumns SelectColumns SelectColumns

Gets or sets the property names of the table entity properties to return when the table query is executed.

TakeCount TakeCount TakeCount

Gets or sets the number of entities the query returns specified in the table query.

Methods

BeginExecuteSegmented(TableContinuationToken, AsyncCallback, Object) BeginExecuteSegmented(TableContinuationToken, AsyncCallback, Object) BeginExecuteSegmented(TableContinuationToken, AsyncCallback, Object)

Begins an asynchronous operation to execute a query and return the results as a result segment.

BeginExecuteSegmented(TableContinuationToken, TableRequestOptions, OperationContext, AsyncCallback, Object) BeginExecuteSegmented(TableContinuationToken, TableRequestOptions, OperationContext, AsyncCallback, Object) BeginExecuteSegmented(TableContinuationToken, TableRequestOptions, OperationContext, AsyncCallback, Object)

Begins an asynchronous operation to execute a query and return the results as a result segment.

Copy() Copy() Copy()

Creates a new copy of the TableQuery instance.

EndExecuteSegmented(IAsyncResult) EndExecuteSegmented(IAsyncResult) EndExecuteSegmented(IAsyncResult)

Ends an asynchronous operation to execute a query and return the results as a result segment.

Execute(TableRequestOptions, OperationContext) Execute(TableRequestOptions, OperationContext) Execute(TableRequestOptions, OperationContext)

Executes a query on a table.

ExecuteSegmented(TableContinuationToken, TableRequestOptions, OperationContext) ExecuteSegmented(TableContinuationToken, TableRequestOptions, OperationContext) ExecuteSegmented(TableContinuationToken, TableRequestOptions, OperationContext)

Executes a segmented query against a table.

ExecuteSegmentedAsync(TableContinuationToken, TableRequestOptions, OperationContext, CancellationToken) ExecuteSegmentedAsync(TableContinuationToken, TableRequestOptions, OperationContext, CancellationToken) ExecuteSegmentedAsync(TableContinuationToken, TableRequestOptions, OperationContext, CancellationToken)

Initiates an asynchronous operation to execute a query and return the results as a result segment.

ExecuteSegmentedAsync(TableContinuationToken, TableRequestOptions, OperationContext) ExecuteSegmentedAsync(TableContinuationToken, TableRequestOptions, OperationContext) ExecuteSegmentedAsync(TableContinuationToken, TableRequestOptions, OperationContext)

Initiates an asynchronous operation to execute a query and return the results as a result segment.

ExecuteSegmentedAsync(TableContinuationToken) ExecuteSegmentedAsync(TableContinuationToken) ExecuteSegmentedAsync(TableContinuationToken)

Initiates an asynchronous operation to execute a query and return the results as a result segment.

ExecuteSegmentedAsync(TableContinuationToken, CancellationToken) ExecuteSegmentedAsync(TableContinuationToken, CancellationToken) ExecuteSegmentedAsync(TableContinuationToken, CancellationToken)

Initiates an asynchronous operation to execute a query and return the results as a result segment.

GetEnumerator() GetEnumerator() GetEnumerator()

Returns an enumerator that iterates through the TableQuery<TElement>.

Select(IList<String>) Select(IList<String>) Select(IList<String>)

Defines the property names of the table entity properties to return when the table query is executed.

Take(Nullable<Int32>) Take(Nullable<Int32>) Take(Nullable<Int32>)

Defines the upper bound for the number of entities the query returns.

Where(String) Where(String) Where(String)

Defines a filter expression for the table query. Only entities that satisfy the specified filter expression will be returned by the query.

Explicit Interface Implementations

IEnumerable.GetEnumerator() IEnumerable.GetEnumerator() IEnumerable.GetEnumerator()

Extension Methods

AsTableQuery<TElement>(IQueryable<TElement>) AsTableQuery<TElement>(IQueryable<TElement>) AsTableQuery<TElement>(IQueryable<TElement>)
Resolve<TElement,TResolved>(IQueryable<TElement>, EntityResolver<TResolved>) Resolve<TElement,TResolved>(IQueryable<TElement>, EntityResolver<TResolved>) Resolve<TElement,TResolved>(IQueryable<TElement>, EntityResolver<TResolved>)
WithContext<TElement>(IQueryable<TElement>, OperationContext) WithContext<TElement>(IQueryable<TElement>, OperationContext) WithContext<TElement>(IQueryable<TElement>, OperationContext)
WithOptions<TElement>(IQueryable<TElement>, TableRequestOptions) WithOptions<TElement>(IQueryable<TElement>, TableRequestOptions) WithOptions<TElement>(IQueryable<TElement>, TableRequestOptions)
AsTableQuery<TElement>(IQueryable<TElement>) AsTableQuery<TElement>(IQueryable<TElement>) AsTableQuery<TElement>(IQueryable<TElement>)

Specifies that a query be returned as a TableQuery object.

Resolve<TElement,TResolved>(IQueryable<TElement>, EntityResolver<TResolved>) Resolve<TElement,TResolved>(IQueryable<TElement>, EntityResolver<TResolved>) Resolve<TElement,TResolved>(IQueryable<TElement>, EntityResolver<TResolved>)

Specifies an entity resolver for the query.

WithContext<TElement>(IQueryable<TElement>, OperationContext) WithContext<TElement>(IQueryable<TElement>, OperationContext) WithContext<TElement>(IQueryable<TElement>, OperationContext)

Specifies an Microsoft.Azure.Storage.OperationContext for the query.

WithOptions<TElement>(IQueryable<TElement>, TableRequestOptions) WithOptions<TElement>(IQueryable<TElement>, TableRequestOptions) WithOptions<TElement>(IQueryable<TElement>, TableRequestOptions)

Specifies a set of TableRequestOptions with which the query will be executed.

AsDocumentQuery<T>(IQueryable<T>) AsDocumentQuery<T>(IQueryable<T>) AsDocumentQuery<T>(IQueryable<T>)

Converts an IQueryable to IDocumentQuery which supports pagination and asynchronous execution in the Azure Cosmos DB service.

AverageAsync(IQueryable<Decimal>, CancellationToken) AverageAsync(IQueryable<Decimal>, CancellationToken) AverageAsync(IQueryable<Decimal>, CancellationToken)

Computes the average of a sequence of Decimal values.

AverageAsync(IQueryable<Double>, CancellationToken) AverageAsync(IQueryable<Double>, CancellationToken) AverageAsync(IQueryable<Double>, CancellationToken)

Computes the average of a sequence of Double values.

AverageAsync(IQueryable<Int32>, CancellationToken) AverageAsync(IQueryable<Int32>, CancellationToken) AverageAsync(IQueryable<Int32>, CancellationToken)

Computes the average of a sequence of Int32 values.

AverageAsync(IQueryable<Int64>, CancellationToken) AverageAsync(IQueryable<Int64>, CancellationToken) AverageAsync(IQueryable<Int64>, CancellationToken)

Computes the average of a sequence of Int64 values.

AverageAsync(IQueryable<Nullable<Decimal>>, CancellationToken) AverageAsync(IQueryable<Nullable<Decimal>>, CancellationToken) AverageAsync(IQueryable<Nullable<Decimal>>, CancellationToken)

Computes the average of a sequence of Nullable<T> values.

AverageAsync(IQueryable<Nullable<Double>>, CancellationToken) AverageAsync(IQueryable<Nullable<Double>>, CancellationToken) AverageAsync(IQueryable<Nullable<Double>>, CancellationToken)

Computes the average of a sequence of Nullable<T> values.

AverageAsync(IQueryable<Nullable<Int32>>, CancellationToken) AverageAsync(IQueryable<Nullable<Int32>>, CancellationToken) AverageAsync(IQueryable<Nullable<Int32>>, CancellationToken)

Computes the average of a sequence of Nullable<T> values.

AverageAsync(IQueryable<Nullable<Int64>>, CancellationToken) AverageAsync(IQueryable<Nullable<Int64>>, CancellationToken) AverageAsync(IQueryable<Nullable<Int64>>, CancellationToken)

Computes the average of a sequence of Nullable<T> values.

AverageAsync(IQueryable<Nullable<Single>>, CancellationToken) AverageAsync(IQueryable<Nullable<Single>>, CancellationToken) AverageAsync(IQueryable<Nullable<Single>>, CancellationToken)

Computes the average of a sequence of Nullable<T> values.

AverageAsync(IQueryable<Single>, CancellationToken) AverageAsync(IQueryable<Single>, CancellationToken) AverageAsync(IQueryable<Single>, CancellationToken)

Computes the average of a sequence of Single values.

CountAsync<TSource>(IQueryable<TSource>, CancellationToken) CountAsync<TSource>(IQueryable<TSource>, CancellationToken) CountAsync<TSource>(IQueryable<TSource>, CancellationToken)

Returns the number of elements in a sequence.

MaxAsync<TSource>(IQueryable<TSource>, CancellationToken) MaxAsync<TSource>(IQueryable<TSource>, CancellationToken) MaxAsync<TSource>(IQueryable<TSource>, CancellationToken)

Returns the maximum value in a generic IQueryable<T>.

MinAsync<TSource>(IQueryable<TSource>, CancellationToken) MinAsync<TSource>(IQueryable<TSource>, CancellationToken) MinAsync<TSource>(IQueryable<TSource>, CancellationToken)

Returns the minimum value in a generic IQueryable<T>.

SumAsync(IQueryable<Decimal>, CancellationToken) SumAsync(IQueryable<Decimal>, CancellationToken) SumAsync(IQueryable<Decimal>, CancellationToken)

Computes the sum of a sequence of Decimal values.

SumAsync(IQueryable<Double>, CancellationToken) SumAsync(IQueryable<Double>, CancellationToken) SumAsync(IQueryable<Double>, CancellationToken)

Computes the sum of a sequence of Double values.

SumAsync(IQueryable<Int32>, CancellationToken) SumAsync(IQueryable<Int32>, CancellationToken) SumAsync(IQueryable<Int32>, CancellationToken)

Computes the sum of a sequence of Int32 values.

SumAsync(IQueryable<Int64>, CancellationToken) SumAsync(IQueryable<Int64>, CancellationToken) SumAsync(IQueryable<Int64>, CancellationToken)

Computes the sum of a sequence of Int64 values.

SumAsync(IQueryable<Nullable<Decimal>>, CancellationToken) SumAsync(IQueryable<Nullable<Decimal>>, CancellationToken) SumAsync(IQueryable<Nullable<Decimal>>, CancellationToken)

Computes the sum of a sequence of Nullable<T> values.

SumAsync(IQueryable<Nullable<Double>>, CancellationToken) SumAsync(IQueryable<Nullable<Double>>, CancellationToken) SumAsync(IQueryable<Nullable<Double>>, CancellationToken)

Computes the sum of a sequence of Nullable<T> values.

SumAsync(IQueryable<Nullable<Int32>>, CancellationToken) SumAsync(IQueryable<Nullable<Int32>>, CancellationToken) SumAsync(IQueryable<Nullable<Int32>>, CancellationToken)

Computes the sum of a sequence of Nullable<T> values.

SumAsync(IQueryable<Nullable<Int64>>, CancellationToken) SumAsync(IQueryable<Nullable<Int64>>, CancellationToken) SumAsync(IQueryable<Nullable<Int64>>, CancellationToken)

Computes the sum of a sequence of Nullable<T> values.

SumAsync(IQueryable<Nullable<Single>>, CancellationToken) SumAsync(IQueryable<Nullable<Single>>, CancellationToken) SumAsync(IQueryable<Nullable<Single>>, CancellationToken)

Computes the sum of a sequence of Nullable<T> values.

SumAsync(IQueryable<Single>, CancellationToken) SumAsync(IQueryable<Single>, CancellationToken) SumAsync(IQueryable<Single>, CancellationToken)

Computes the sum of a sequence of Single values.

IsDefined(Object) IsDefined(Object) IsDefined(Object)

Determines if a certain property is defined or not.

IsNull(Object) IsNull(Object) IsNull(Object)

Determines if a certain property is null or not.

IsPrimitive(Object) IsPrimitive(Object) IsPrimitive(Object)

Determines if a certain property is of premitive JSON type.

ToCommaSeparatedString<T>(IEnumerable<T>) ToCommaSeparatedString<T>(IEnumerable<T>) ToCommaSeparatedString<T>(IEnumerable<T>)

Converts the elements of a collection to strings and concatenates them into a comma-separated list, or returns null for null or empty collections.

AsTableQuery<TElement>(IQueryable<TElement>) AsTableQuery<TElement>(IQueryable<TElement>) AsTableQuery<TElement>(IQueryable<TElement>)

Specifies that a query be returned as a TableQuery object.

Resolve<TElement,TResolved>(IQueryable<TElement>, EntityResolver<TResolved>) Resolve<TElement,TResolved>(IQueryable<TElement>, EntityResolver<TResolved>) Resolve<TElement,TResolved>(IQueryable<TElement>, EntityResolver<TResolved>)

Specifies an entity resolver for the query.

WithContext<TElement>(IQueryable<TElement>, OperationContext) WithContext<TElement>(IQueryable<TElement>, OperationContext) WithContext<TElement>(IQueryable<TElement>, OperationContext)

Specifies an OperationContext for the query.

WithOptions<TElement>(IQueryable<TElement>, TableRequestOptions) WithOptions<TElement>(IQueryable<TElement>, TableRequestOptions) WithOptions<TElement>(IQueryable<TElement>, TableRequestOptions)

Specifies a set of TableRequestOptions with which the query will be executed.

Applies to