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')
See the version list below for details.
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
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version History
Version | Downloads | Last updated |
---|---|---|
3.0.80 | 1,686 | 9/21/2020 |
3.0.70 | 6,830 | 9/3/2019 |
2.0.40 | 2,576 | 6/26/2018 |
2.0.39 | 488 | 6/21/2018 |
2.0.37 | 573 | 6/18/2018 |
2.0.35 | 462 | 6/15/2018 |
2.0.33 | 1,948 | 6/6/2018 |
2.0.31 | 536 | 5/14/2018 |
2.0.29 | 630 | 3/18/2018 |
2.0.28 | 485 | 3/18/2018 |
2.0.24 | 501 | 3/17/2018 |
2.0.23 | 522 | 3/17/2018 |
2.0.21 | 590 | 2/26/2018 |
2.0.19 | 605 | 2/11/2018 |
2.0.18 | 485 | 2/11/2018 |
2.0.16 | 479 | 2/11/2018 |
2.0.4 | 506 | 2/6/2018 |
2.0.3 | 541 | 1/23/2018 |