Microsoft.Azure.Documents.OData.Sql 2.0.2

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:
         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

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

Repository Stars
Azure/azure-stream-analytics
Azure Stream Analytics

Version History

Version Downloads Last updated
2.0.2 12,181 11/1/2016
2.0.1 478 10/25/2016
2.0.0 470 10/25/2016
1.0.0 419 10/21/2016