SqlKata 1.0.0-beta-32

A powerful Sql Query Builder written in C#. it's secure and framework agnostic.

Inspired by the top Query Builders available, like Laravel Query Builder, and Knex.

SqlKata has an expressive API. It follows a clean naming convention, which is very similar to the SQL syntax.

It makes writing SQL queries easy and funny, with no need to read long pages of documentations.

It provides a level of abstraction over the supported database engines, that allows you to work with multiple databases with the same unified API.

SqlKata supports complex queries, such as nested conditions, selection from SubQuery, filtering over SubQueries, Conditional Statements, Deep Joins and others.

Currently it has built-in compilers for SqlServer 2008 and above, MySql 5 and PostgreSql 9.

This is a prerelease version of SqlKata.
There is a newer version of this package available.
See the version list below for details.
Install-Package SqlKata -Version 1.0.0-beta-32
dotnet add package SqlKata --version 1.0.0-beta-32
<PackageReference Include="SqlKata" Version="1.0.0-beta-32" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SqlKata --version 1.0.0-beta-32
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

Add the DeepJoin functionality, add the insert and update methods

Showing the top 1 GitHub repositories that depend on SqlKata:

Repository Stars
siteserver/cms
SiteServer CMS 基于.NET平台,能够以最低的成本、最少的人力投入在最短的时间内架设一个功能齐全、性能优异、规模庞大并易于维护的网站平台。

Read more about the GitHub Usage information on our documentation.

Version History

Version Downloads Last updated
1.1.8-ci-712 15,245 8/7/2019
1.1.8-ci-709 94 8/7/2019
1.1.7 129,706 2/21/2019
1.1.6 17,076 1/8/2019
1.1.5 1,400 1/4/2019
1.1.3 27,996 10/1/2018
1.1.2 1,961 9/24/2018
1.1.0 223 9/24/2018
1.0.4 13,951 7/31/2018
1.0.3 4,704 7/20/2018
1.0.1 491 7/17/2018
1.0.0-beta-553 296 7/15/2018
1.0.0-beta-484 5,427 5/14/2018
1.0.0-beta-458 8,857 4/8/2018
1.0.0-beta-454 361 3/29/2018
1.0.0-beta-450 252 3/28/2018
1.0.0-beta-441 416 3/21/2018
1.0.0-beta-411 2,620 1/21/2018
1.0.0-beta-409 298 1/21/2018
1.0.0-beta-408 293 1/21/2018
1.0.0-beta-405 289 1/20/2018
1.0.0-beta-357 9,425 11/18/2017
1.0.0-beta-355 359 11/3/2017
1.0.0-beta-354 377 10/21/2017
1.0.0-beta-353 509 8/14/2017
1.0.0-beta-352 274 8/12/2017
1.0.0-beta-351 263 8/12/2017
1.0.0-beta-35 277 8/11/2017
1.0.0-beta-345 266 8/11/2017
1.0.0-beta-344 272 8/11/2017
1.0.0-beta-343 281 8/11/2017
1.0.0-beta-342 274 8/11/2017
1.0.0-beta-341 272 8/10/2017
1.0.0-beta-34 282 8/10/2017
1.0.0-beta-32 400 5/21/2017
1.0.0-beta-31 297 5/17/2017
1.0.0-beta-3 283 5/15/2017
1.0.0-beta-2 289 5/10/2017
1.0.0-beta-1 306 5/9/2017
Show less