Lambda.Azure.CosmosDb.OData.Sql
2.0.4
See the version list below for details.
dotnet add package Lambda.Azure.CosmosDb.OData.Sql --version 2.0.4
NuGet\Install-Package Lambda.Azure.CosmosDb.OData.Sql -Version 2.0.4
<PackageReference Include="Lambda.Azure.CosmosDb.OData.Sql" Version="2.0.4" />
paket add Lambda.Azure.CosmosDb.OData.Sql --version 2.0.4
#r "nuget: Lambda.Azure.CosmosDb.OData.Sql, 2.0.4"
// Install Lambda.Azure.CosmosDb.OData.Sql as a Cake Addin #addin nuget:?package=Lambda.Azure.CosmosDb.OData.Sql&version=2.0.4 // Install Lambda.Azure.CosmosDb.OData.Sql as a Cake Tool #tool nuget:?package=Lambda.Azure.CosmosDb.OData.Sql&version=2.0.4
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')
field/any(f:f eq 'value') => ARRAY_CONTAINS(c.field,'value')
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net452 is compatible. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
-
- Microsoft.AspNet.OData (>= 5.9.0 && < 6.0.0)
- Microsoft.Azure.DocumentDB (>= 1.9.5)
- Microsoft.Data.OData (>= 5.6.0)
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 |
---|---|---|
4.1.0 | 28,925 | 2/22/2022 |
3.0.87 | 1,239 | 11/10/2021 |
3.0.83 | 461 | 11/2/2021 |
3.0.80 | 5,962 | 9/21/2020 |
3.0.70 | 7,433 | 9/3/2019 |
2.0.40 | 3,225 | 6/26/2018 |
2.0.39 | 1,010 | 6/21/2018 |
2.0.37 | 1,098 | 6/18/2018 |
2.0.35 | 974 | 6/15/2018 |
2.0.33 | 2,488 | 6/6/2018 |
2.0.31 | 1,082 | 5/14/2018 |
2.0.29 | 1,132 | 3/18/2018 |
2.0.28 | 984 | 3/18/2018 |
2.0.24 | 1,013 | 3/17/2018 |
2.0.23 | 1,065 | 3/17/2018 |
2.0.21 | 1,259 | 2/26/2018 |
2.0.19 | 1,115 | 2/11/2018 |
2.0.18 | 1,030 | 2/11/2018 |
2.0.16 | 986 | 2/11/2018 |
2.0.4 | 1,063 | 2/6/2018 |
2.0.3 | 1,132 | 1/23/2018 |
2.0.4 Added support for ARRAY_CONTAINS
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