Microsoft.Azure.Documents.OData.Sql 2.0.2

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
         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')

Install-Package Microsoft.Azure.Documents.OData.Sql -Version 2.0.2
dotnet add package Microsoft.Azure.Documents.OData.Sql --version 2.0.2
<PackageReference Include="Microsoft.Azure.Documents.OData.Sql" Version="2.0.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Microsoft.Azure.Documents.OData.Sql --version 2.0.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

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

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on Microsoft.Azure.Documents.OData.Sql:

Repository Stars
Azure Stream Analytics

Version History

Version Downloads Last updated
2.0.2 18,585 11/1/2016
2.0.1 680 10/25/2016
2.0.0 630 10/25/2016
1.0.0 584 10/21/2016