[This is prerelease documentation and is subject to change in future releases.]
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.
LINQ Query Operators
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.
Supported Query Operators
|
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. | |
Unsupported Query Operators
|
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. | |
See Also