Bharat.DevExtreme.Helpers.DataSource 1.0.0.1

Creates a sql where clause from DevExtreme remote datasource with filtering.

Install-Package Bharat.DevExtreme.Helpers.DataSource -Version 1.0.0.1
dotnet add package Bharat.DevExtreme.Helpers.DataSource --version 1.0.0.1
<PackageReference Include="Bharat.DevExtreme.Helpers.DataSource" Version="1.0.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Bharat.DevExtreme.Helpers.DataSource --version 1.0.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

DevExtreme helpers remote datasource.

Build status
Build status

Nuget link: https://www.nuget.org/packages/Bharat.DevExtreme.Helpers.DataSource/

var Builder = new WhereClauseBuilder();
var json = "[\"CustomerID\",\"=\",\"ALFKI\"]";
var jarray = JArray.Parse(json);
var sqlWhereClause = Builder.BuildFor(jarray);

Outputs:

CustomerID = "ALFKI"

In sql you can write

Exec('Select * from customers where ' + @sqlWhereClause);

There is an overloaded version of WhereClauseBuilder you can provide your own implentation ISQLColumnProvider if you are using table aliases you can customize there.

DevExtreme helpers remote datasource.

Build status
Build status

Nuget link: https://www.nuget.org/packages/Bharat.DevExtreme.Helpers.DataSource/

var Builder = new WhereClauseBuilder();
var json = "[\"CustomerID\",\"=\",\"ALFKI\"]";
var jarray = JArray.Parse(json);
var sqlWhereClause = Builder.BuildFor(jarray);

Outputs:

CustomerID = "ALFKI"

In sql you can write

Exec('Select * from customers where ' + @sqlWhereClause);

There is an overloaded version of WhereClauseBuilder you can provide your own implentation ISQLColumnProvider if you are using table aliases you can customize there.

Release Notes

First release.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.0.1 210 12/2/2018
1.0.0 168 12/1/2018