ADCCure.Azure.Documents.OData.Sql 2.1.13

.NET Framework 4.6.2
Install-Package ADCCure.Azure.Documents.OData.Sql -Version 2.1.13
dotnet add package ADCCure.Azure.Documents.OData.Sql --version 2.1.13
<PackageReference Include="ADCCure.Azure.Documents.OData.Sql" Version="2.1.13" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add ADCCure.Azure.Documents.OData.Sql --version 2.1.13
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: ADCCure.Azure.Documents.OData.Sql, 2.1.13"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install ADCCure.Azure.Documents.OData.Sql as a Cake Addin
#addin nuget:?package=ADCCure.Azure.Documents.OData.Sql&version=2.1.13

// Install ADCCure.Azure.Documents.OData.Sql as a Cake Tool
#tool nuget:?package=ADCCure.Azure.Documents.OData.Sql&version=2.1.13
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Currently it supports below query mappings:
     field                       => c.field
     parent/child                => c.parent.child
     Namespace.EnumType'enumVal' => 'enumVal'

     $select  => SELECT
     $filter  => WHERE
     $top     => TOP
     $orderby => ORDER BY

     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')
     geography'POLYGON((31.8 -5, 32 -5, 32 -4.7, 31.8 -4.7, 31.8 -5))
     => ST_INTERSECTS(c.area,{\"type\":\"Polygon\",\"coordinates\":[[[31.8,-5.0],[32.0,-5.0],[32.0,-4.7],[31.8,-4.7],[31.8,-5.0]]]})
     geography'POINT(31.9 -4.8)') lt 100 => ST_DISTANCE(c.location,{\"type\":\"Point\",\"coordinates\":[31.9,-4.8]}) < 100
     $count=true&$filter=englishName eq 'Microsoft' => VALUE COUNT(1) FROM c WHERE c.englishName = 'Microsoft'

Product Versions
.NET Framework net462 net463 net47 net471 net472 net48
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

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.13 1,214 3/1/2018
2.1.12 1,016 10/24/2017
2.1.5 799 10/15/2017
2.1.4 772 10/15/2017
2.1.3 838 10/14/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