Lambda.Azure.CosmosDb.OData.Sql 2.0.3

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 Lambda.Azure.CosmosDb.OData.Sql -Version 2.0.3

dotnet add package Lambda.Azure.CosmosDb.OData.Sql --version 2.0.3

<PackageReference Include="Lambda.Azure.CosmosDb.OData.Sql" Version="2.0.3" />

paket add Lambda.Azure.CosmosDb.OData.Sql --version 2.0.3

#r "nuget: Lambda.Azure.CosmosDb.OData.Sql, 2.0.3"

Release Notes

2.0.3 Added support for DateTimeOffset
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

Dependencies

• • Microsoft.AspNet.OData (>= 5.9.0 && < 6.0.0)
  • Microsoft.Azure.DocumentDB (>= 1.9.5)
  • Microsoft.Data.OData (>= 5.6.0)

Used By

Version History