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.
#r "nuget: SqlKata, 1.0.0-beta-32"
#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 SqlKata as a Cake Addin
#addin nuget:?package=SqlKata&version=1.0.0-beta-32&prerelease

// Install SqlKata as a Cake Tool
#tool nuget:?package=SqlKata&version=1.0.0-beta-32&prerelease
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

NuGet packages (43)

Showing the top 5 NuGet packages that depend on SqlKata:

Package Downloads
SqlKata.Execution
Adds the execution capabilities for SqlKata
SS.CMS
SiteServer CMS
Blauhaus.Domain.Client.Sqlite
Package Description
Canducci.SqlKata.Dapper
SqlKata + Dapper + Canducci Wrapper Extensions
Datory
基于 Dapper 及 SqlKata 的通用数据库操作库,支持SqlServer、MySql、PostgreSql以及SQLite。

GitHub repositories (3)

Showing the top 3 popular GitHub repositories that depend on SqlKata:

Repository Stars
siteserver/cms
SS CMS 基于 .NET Core,能够以最低的成本、最少的人力投入在最短的时间内架设一个功能齐全、性能优异、规模庞大并易于维护的网站平台。
planetarium/libplanet
Blockchain core in C#/.NET for persistent peer-to-peer online games
buraksenyurt/skynet
Some kinds of programming tutorials on MacOS/Windows/Linux. There are 41 sample applications.

Version History

Version Downloads Last updated
2.3.2 30,076 3/14/2021
2.2.0 396,260 6/1/2020
2.2.0-ci-788 207 6/1/2020
2.1.0 4,732 5/29/2020
2.1.0-ci-786 207 5/29/2020
2.0.2-ci-771 34,270 1/5/2020
1.1.8-CI-768 615 1/5/2020
1.1.8-ci-712 58,206 8/7/2019
1.1.8-ci-709 526 8/7/2019
1.1.7 573,029 2/21/2019
1.1.6 27,582 1/8/2019
1.1.5 2,420 1/4/2019
1.1.3 46,233 10/1/2018
1.1.2 2,652 9/24/2018
1.1.0 529 9/24/2018
1.0.4 20,400 7/31/2018
1.0.3 5,088 7/20/2018
1.0.1 1,052 7/17/2018
1.0.0-beta-553 590 7/15/2018
1.0.0-beta-484 6,357 5/14/2018
1.0.0-beta-458 10,640 4/8/2018
1.0.0-beta-454 658 3/29/2018
1.0.0-beta-450 532 3/28/2018
1.0.0-beta-441 886 3/21/2018
1.0.0-beta-411 6,758 1/21/2018
1.0.0-beta-409 604 1/21/2018
1.0.0-beta-408 568 1/21/2018
1.0.0-beta-405 574 1/20/2018
1.0.0-beta-357 11,078 11/18/2017
1.0.0-beta-355 797 11/3/2017
1.0.0-beta-354 852 10/21/2017
1.0.0-beta-353 957 8/14/2017
1.0.0-beta-352 529 8/12/2017
1.0.0-beta-351 513 8/12/2017
1.0.0-beta-35 535 8/11/2017
1.0.0-beta-345 537 8/11/2017
1.0.0-beta-344 532 8/11/2017
1.0.0-beta-343 530 8/11/2017
1.0.0-beta-342 528 8/11/2017
1.0.0-beta-341 532 8/10/2017
1.0.0-beta-34 535 8/10/2017
1.0.0-beta-32 706 5/21/2017
1.0.0-beta-31 553 5/17/2017
1.0.0-beta-3 547 5/15/2017
1.0.0-beta-2 555 5/10/2017
1.0.0-beta-1 568 5/9/2017
Show less