RestSQL 1.0.0
.NET Standard 2.0
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package RestSQL --version 1.0.0
NuGet\Install-Package RestSQL -Version 1.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="RestSQL" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add RestSQL --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: RestSQL, 1.0.0"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install RestSQL as a Cake Addin
#addin nuget:?package=RestSQL&version=1.0.0
// Install RestSQL as a Cake Tool
#tool nuget:?package=RestSQL&version=1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
RestSQL
Port of: https://github.com/mmrath/rsql-parser
C# Sql Where Clause Parser to be used as Rest Parameters to filter data
This parser is strong using Visitor Pattern: The IExpressionBuilder<T> should be implemented and then call to build:
RestSQL<T>.Parse(query, this);
You can base on our test to implement your own strategy:
var testExpressionBuilder = new TestExpressionBuilder();
testExpressionBuilder.Build("ab > 'DE' and (c = d or d > 4.3) and e>4 or rere in (20,30,40,50) and defer between 2 and 3 or rerer not in ('432','234324')");
Implemented strategies:
SqlKata.QueryBuilder
var t = new Query().From("tblLalala").Where("Name", "Igor").Where(c=>c.Where("status","1").OrWhere("status","2"));
var compiler = new Oracle11gCompiler();
var testExpressionBuilder = new SqlKataBuilder();
var q = testExpressionBuilder.Build("ab > 'DE' and (c = d or d > 4.3) and e>4 or rere in (20,30,40,50) and defer between 2 and 3 or rerer not in ('432','234324')");
var qb = testExpressionBuilder.BuildFrom("ab > 'DE' and (c = d or d > 4.3) and e>4 or rere in (20,30,40,50) and defer between 2 and 3 or rerer not in ('432','234324')", t);
var sql = compiler.Compile(q.From("MyTable"));
var sqlb = compiler.Compile(qb);
Product | Versions |
---|---|
.NET | net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows |
.NET Core | netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1 |
.NET Standard | netstandard2.0 netstandard2.1 |
.NET Framework | net461 net462 net463 net47 net471 net472 net48 net481 |
MonoAndroid | monoandroid |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen40 tizen60 |
Xamarin.iOS | xamarinios |
Xamarin.Mac | xamarinmac |
Xamarin.TVOS | xamarintvos |
Xamarin.WatchOS | xamarinwatchos |
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.0
- Antlr4.Runtime (>= 4.6.6)
NuGet packages (2)
Showing the top 2 NuGet packages that depend on RestSQL:
Package | Downloads |
---|---|
RestSQL.SqlKata
SqlKata QueryBuilder implementation for RestSQL |
|
RestSQL.NPoco
NPoco QueryBuilder implementation for RestSQL |
GitHub repositories
This package is not used by any popular GitHub repositories.