 |
VOOZH | about |
|
VOOZH | about |
dotnet add package Sels.SQL.QueryBuilder --version 1.0.0-beta-000345
NuGet\Install-Package Sels.SQL.QueryBuilder -Version 1.0.0-beta-000345
<PackageReference Include="Sels.SQL.QueryBuilder" Version="1.0.0-beta-000345" />
<PackageVersion Include="Sels.SQL.QueryBuilder" Version="1.0.0-beta-000345" />Directory.Packages.props
<PackageReference Include="Sels.SQL.QueryBuilder" />Project file
paket add Sels.SQL.QueryBuilder --version 1.0.0-beta-000345
#r "nuget: Sels.SQL.QueryBuilder, 1.0.0-beta-000345"
#:package Sels.SQL.QueryBuilder@1.0.0-beta-000345
#addin nuget:?package=Sels.SQL.QueryBuilder&version=1.0.0-beta-000345&prereleaseInstall as a Cake Addin
#tool nuget:?package=Sels.SQL.QueryBuilder&version=1.0.0-beta-000345&prereleaseInstall as a Cake Tool
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 net5.0 was computed. net5.0-windows net5.0-windows was computed. net6.0 net6.0 was computed. net6.0-android net6.0-android was computed. net6.0-ios net6.0-ios was computed. net6.0-maccatalyst net6.0-maccatalyst was computed. net6.0-macos net6.0-macos was computed. net6.0-tvos net6.0-tvos was computed. net6.0-windows net6.0-windows was computed. net7.0 net7.0 was computed. net7.0-android net7.0-android was computed. net7.0-ios net7.0-ios was computed. net7.0-maccatalyst net7.0-maccatalyst was computed. net7.0-macos net7.0-macos was computed. net7.0-tvos net7.0-tvos was computed. net7.0-windows net7.0-windows was computed. net8.0 net8.0 was computed. net8.0-android net8.0-android was computed. net8.0-browser net8.0-browser was computed. net8.0-ios net8.0-ios was computed. net8.0-maccatalyst net8.0-maccatalyst was computed. net8.0-macos net8.0-macos was computed. net8.0-tvos net8.0-tvos was computed. net8.0-windows net8.0-windows was computed. net9.0 net9.0 was computed. net9.0-android net9.0-android was computed. net9.0-browser net9.0-browser was computed. net9.0-ios net9.0-ios was computed. net9.0-maccatalyst net9.0-maccatalyst was computed. net9.0-macos net9.0-macos was computed. net9.0-tvos net9.0-tvos was computed. net9.0-windows net9.0-windows was computed. net10.0 net10.0 was computed. net10.0-android net10.0-android was computed. net10.0-browser net10.0-browser was computed. net10.0-ios net10.0-ios was computed. net10.0-maccatalyst net10.0-maccatalyst was computed. net10.0-macos net10.0-macos was computed. net10.0-tvos net10.0-tvos was computed. net10.0-windows net10.0-windows was computed. |
| .NET Core | netcoreapp3.0 netcoreapp3.0 was computed. netcoreapp3.1 netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.1 netstandard2.1 is compatible. |
| MonoAndroid | monoandroid monoandroid was computed. |
| MonoMac | monomac monomac was computed. |
| MonoTouch | monotouch monotouch was computed. |
| Tizen | tizen60 tizen60 was computed. |
| Xamarin.iOS | xamarinios xamarinios was computed. |
| Xamarin.Mac | xamarinmac xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos xamarinwatchos was computed. |
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. |
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 1.0.0-beta-000345 | 256 | 11/25/2024 |
| 1.0.0-beta-000343 | 232 | 11/6/2024 |
| 1.0.0-beta-000337 | 244 | 8/18/2024 |
| 1.0.0-beta-000331 | 218 | 6/25/2024 |
| 1.0.0-beta-000330 | 253 | 6/25/2024 |
| 1.0.0-beta-000325 | 265 | 4/26/2024 |
| 1.0.0-beta-000322 | 267 | 4/3/2024 |
| 1.0.0-beta-000321 | 259 | 4/1/2024 |
| 1.0.0-beta-000319 | 275 | 1/29/2024 |
| 1.0.0-beta-000318 | 232 | 1/28/2024 |
| 1.0.0-beta-000314 | 234 | 1/26/2024 |
| 1.0.0-beta-000313 | 272 | 1/20/2024 |
| 1.0.0-beta-000312 | 317 | 1/7/2024 |
| 1.0.0-beta-000311 | 316 | 1/3/2024 |
| 1.0.0-beta-000310 | 262 | 1/2/2024 |
| 1.0.0-beta-000309 | 288 | 12/28/2023 |
| 1.0.0-beta-000308 | 253 | 12/22/2023 |
| 1.0.0-beta-000307 | 311 | 12/8/2023 |
| 1.0.0-beta-000306 | 266 | 12/8/2023 |
| 1.0.0-beta-000301 | 331 | 10/22/2023 |