RestSQL.NPoco 1.0.6

There is a newer version of this package available.
See the version list below for details.
Install-Package RestSQL.NPoco -Version 1.0.6
dotnet add package RestSQL.NPoco --version 1.0.6
<PackageReference Include="RestSQL.NPoco" Version="1.0.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add RestSQL.NPoco --version 1.0.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: RestSQL.NPoco, 1.0.6"
#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.NPoco as a Cake Addin
#addin nuget:?package=RestSQL.NPoco&version=1.0.6

// Install RestSQL.NPoco as a Cake Tool
#tool nuget:?package=RestSQL.NPoco&version=1.0.6
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')");

Nuget Package: https://www.nuget.org/packages/RestSQL/

Implemented strategies:

  • SqlKata.QueryBuilder

https://www.nuget.org/packages/RestSQL.SqlKata/

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);
  • NPoco

https://www.nuget.org/packages/RestSQL.NPoco/

var s = new SqlBuilder();
s.Where("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 db = new Database("conn");
db.Fetch<User>(template);

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
1.0.8 40 10/12/2021
1.0.7 118 10/12/2021
1.0.6 231 8/25/2020
1.0.1 284 8/18/2019
1.0.0 360 1/30/2019