Info
Version: | 2.1.12 |
Author(s): | Ziyou Zheng, Egbert Nierop, ntanaka |
Last Update: | Tuesday, October 24, 2017 |
.NET Fiddle: | Create the first Fiddle |
Project Url: | https://github.com/egbertn/azure-documentdb-odata-sql |
NuGet Url: | https://www.nuget.org/packages/ADCCure.Azure.Documents.OData.Sql |
Install
Install-Package ADCCure.Azure.Documents.OData.Sql
dotnet add package ADCCure.Azure.Documents.OData.Sql
paket add ADCCure.Azure.Documents.OData.Sql
ADCCure.Azure.Documents.OData.Sql Download (Unzip the "nupkg" after downloading)
Dependencies
- Microsoft.AspNet.OData(>= 6.0.0)
- GeoJSON.Net(>= 1.1.64)
- Microsoft.Azure.DocumentDB(>= 1.9.5)
- Microsoft.OData.Core(>= 7.0.0)
- Microsoft.OData.Edm(>= 7.0.0)
- Microsoft.Spatial(>= 7.0.0)
- Newtonsoft.Json(>= 6.0.8)
- NETStandard.Library(>= 1.6.1)
Tags
primitive:
field => c.field
parent/child => c.parent.child
Namespace.EnumType'enumVal' => 'enumVal'
queries:
$select => SELECT
$filter => WHERE
$top => TOP
$orderby => ORDER BY
functions:
Items/any(a: a/field op 'value') => SELECT value c FROM c JOIN a IN c.Items WHERE a.field op 'value'
contains(field,'value') => CONTAINS(c.field,'value')
startswith(field,'value') => STARTSWITH(c.field,'value')
endswith(field,'value') => ENDSWITH(c.field,'value')
toupper(field) => UPPER(c.field)
tolower(field) => LOWER(c.field)
length(field) => LENGTH(c.field)
indexof(field,'value') => INDEX_OF(c.field,'value')
substring(field,idx1,idx2) => SUBSTRING(c.field,idx1,idx2)
trim(field) => LTRIM(RTRIM(c.englishName))
concat(field,'value') => CONCAT(c.englishName,'value').