ADCCure.Azure.Documents.OData.Sql
2.1.12
Package is superseded by Odata itself
dotnet add package ADCCure.Azure.Documents.OData.Sql --version 2.1.12
NuGet\Install-Package ADCCure.Azure.Documents.OData.Sql -Version 2.1.12
<PackageReference Include="ADCCure.Azure.Documents.OData.Sql" Version="2.1.12" />
paket add ADCCure.Azure.Documents.OData.Sql --version 2.1.12
#r "nuget: ADCCure.Azure.Documents.OData.Sql, 2.1.12"
// Install ADCCure.Azure.Documents.OData.Sql as a Cake Addin #addin nuget:?package=ADCCure.Azure.Documents.OData.Sql&version=2.1.12 // Install ADCCure.Azure.Documents.OData.Sql as a Cake Tool #tool nuget:?package=ADCCure.Azure.Documents.OData.Sql&version=2.1.12
Currently it supports below query mappings:
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')
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net462 is compatible. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
-
- Microsoft.AspNet.OData (>= 6.0.0)
- Microsoft.AspNet.WebApi.Client (>= 5.2.3)
- Microsoft.AspNet.WebApi.Core (>= 5.2.3)
- Microsoft.Azure.DocumentDB (>= 1.9.5)
- Microsoft.Extensions.DependencyInjection (>= 1.1.1)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 1.1.1)
- Microsoft.OData.Core (>= 7.0.0)
- Microsoft.OData.Edm (>= 7.0.0)
- Microsoft.Spatial (>= 7.0.0)
- NETStandard.Library (>= 1.6.1)
- Newtonsoft.Json (>= 6.0.8)
- System.Diagnostics.DiagnosticSource (>= 4.4.1)
- System.Net.Http (>= 4.3.2)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated | |
---|---|---|---|
2.1.12 | 1,369 | 10/24/2017 |
2.1.12 Fix Guid translation with quotes encapsulated
2.1.11 Resolve nullreference exception on empty $filter
2.1.5 Improved Enum parsing
2.1.4 Improved dependency versions
2.1.3 Added support for any. Note, 'all' not supported.
2.0.2 Added support for functions: length(), indexof(), substring(), trim(), concat()
2.0.1 Added support for functions: contains(), startswith(), endswith(), toupper() and tolower()
2.0.0 Breaking changes: Simplified usage with newly introuduced class ODataToSqlTranslator
1.0.0 Initial release