Sels.SQL.QueryBuilder
1.0.0-beta-000343
dotnet add package Sels.SQL.QueryBuilder --version 1.0.0-beta-000343
NuGet\Install-Package Sels.SQL.QueryBuilder -Version 1.0.0-beta-000343
<PackageReference Include="Sels.SQL.QueryBuilder" Version="1.0.0-beta-000343" />
paket add Sels.SQL.QueryBuilder --version 1.0.0-beta-000343
#r "nuget: Sels.SQL.QueryBuilder, 1.0.0-beta-000343"
// Install Sels.SQL.QueryBuilder as a Cake Addin #addin nuget:?package=Sels.SQL.QueryBuilder&version=1.0.0-beta-000343&prerelease // Install Sels.SQL.QueryBuilder as a Cake Tool #tool nuget:?package=Sels.SQL.QueryBuilder&version=1.0.0-beta-000343&prerelease
Framework for creating sql queries using fluent builders.
Uses a (somewhat) easy to extend expression system that gets compiled into SQL using compilers.
Can be used for simple queries or more advanced queries (Joins, conditions (WHERE), sub queries, order by, group by, functions (MIN, AVG, ...), Union, case when then else, ...)
Supports the following sql statements:
- Insert
- Update
- Delete
- Select
- Common table expressions (CTE)
- If, else if, else
- Declare variable
- Set variable
Use IServiceCollection.AddSqlQueryProvider() or IServiceCollection.AddCachedSqlQueryProvider to inject ISqlQueryProvider or ICachedSqlQueryProvider to start building sql queries.
Official compilers:
- Sels.SQL.QueryBuilder.MySQL
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
| .NET Core | netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.1 is compatible. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.1
- Microsoft.Extensions.Caching.Abstractions (>= 8.0.0)
- Microsoft.Extensions.Caching.Memory (>= 8.0.0)
- Sels.Core.Legacy (>= 1.0.0-beta-000343)
- Sels.Core.ServiceBuilder (>= 2.0.0-beta-000343)
- Sels.ObjectValidationFramework (>= 6.0.0-beta-000343)
NuGet packages (3)
Showing the top 3 NuGet packages that depend on Sels.SQL.QueryBuilder:
| Package | Downloads |
|---|---|
|
Sels.Core.Data.SQL
Contains code for working with Sql based databases. Used by projects maintained here: https://github.com/Jenssels1998 |
|
|
Sels.SQL.QueryBuilder.MySQL
MySQL compiler for Sels.SQL.QueryBuilder. Supports MySQL and MariaDB. Custom expressions: - SELECT FOR UPDATE - INSERT ON DUPLICATE KEY - SELECT LIMIT - RECURSIVE Cte - MariaDB RETURNING - NOW, UTC_TIMESTAMP, DATE_ADD, CONCACT functions Start creating queries using one of the following static helper methods: - Sels.SQL.QueryBuilder.MySQL.MySql.Insert(); - Sels.SQL.QueryBuilder.MySQL.MySql.Update(); - Sels.SQL.QueryBuilder.MySQL.MySql.Delete(); - Sels.SQL.QueryBuilder.MySQL.MySql.Select(); - Sels.SQL.QueryBuilder.MySQL.MySql.With(); - Sels.SQL.QueryBuilder.MySQL.MySql.If(); - Sels.SQL.QueryBuilder.MySQL.MySql.Set(); Use IServiceCollection.AddMySqlQueryProvider() or IServiceCollection.AddCachedMySqlQueryProvider to inject ISqlQueryProvider or ICachedSqlQueryProvider to start building MySQL queries. |
|
|
Sels.DistributedLocking.SQL
Locking provider that uses a ISqlLockProvider to manage lock state. Uses basic sql locking for concurrency. Exposes a BaseSqlLockRepository that can be implemented to provide support for more RDBMS. |
GitHub repositories
This package is not used by any popular GitHub repositories.