Exportera (0) Skriv ut
Visa allt
EN
Det här innehållet finns inte tillgängligt på ditt språk men här finns den engelska versionen,

Query Operators Supported for the Table Service

Updated: August 13, 2014

The Microsoft® .NET Client Library supports data service queries by using language-integrated queries (LINQ). The client library handles the details of mapping the LINQ statement to the appropriate URI for the Table service and of retrieving the specified resources as .NET objects.

The following tables note which LINQ query operators are supported for use with the Table service. For more information about LINQ query operators, see LINQ: .NET Language-Integrated Query.

 

LINQ operator Table service support Additional information

From

Supported as defined.

Where

Supported as defined.

Take

Supported, with some restrictions.

The value specified for the Take operator must be less than or equal to 1,000. If it is greater than 1,000, the service returns status code 400 (Bad Request).

If the Take operator is not specified, a maximum of 1,000 entries will be returned.

First, FirstOrDefault

Supported.

Select

Supported for version 2011-08-18 and newer.

Projection is supported. For more information, see Writing LINQ Queries Against the Table Service.

 

LINQ operator Table service support Additional information

GroupBy

Not Supported.

OrderBy, OrderByDescending

Not Supported.

ThenBy, ThenByDescending

Not Supported.

Average

Not Supported.

Min

Not Supported.

Max

Not Supported.

Last, LastOrDefault

Not Supported.

Skip

Count, LongCount

Not Supported.

Sum

Not Supported.

TakeWhile

Not Supported.

SkipWhile

Not Supported.

Join, GroupJoin

Not Supported.

Single

Not Supported.

OfType

Not Supported.

SelectMany

Not Supported.

Concat

Not Supported.

ElementAt, ElemenatAtOrDefault

Not Supported.

Distinct

Not Supported.

Except

Not Supported.

Intersect

Not Supported.

Union

Not Supported.

All

Not Supported.

Any

Not Supported.

Contains

Not Supported.

SequenceEqual

Not Supported.

Empty, Range, Repeat

Not Supported.

SingleOrDefault

Not Supported.

Reverse

Not Supported.

See Also

Visa:
© 2014 Microsoft