AcheterBuy
1-855-856-7678
AssistanceSupport
Query Operators (Table Service Support)
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.
In addition to using LINQ syntax, you may also use the client library to query the Table service by calling the CreateQuery method of the DataServiceContext class.
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. |
|
| LINQ operator | Table service support | Additional information |
|---|---|---|
|
Select |
Not supported. |
All properties of an entity are retrieved on any read operation. Projection is not supported. |
|
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. |
|
Voir aussi
Ajouts de la communauté
Microsoft réalise une enquête en ligne pour recueillir votre opinion sur le site Web de MSDN. Si vous choisissez d’y participer, cette enquête en ligne vous sera présentée lorsque vous quitterez le site Web de MSDN.
Si vous souhaitez y participer,
Si vous souhaitez y participer,
