Zq.SQLBuilder.Core
1.0.4.9
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package Zq.SQLBuilder.Core --version 1.0.4.9
NuGet\Install-Package Zq.SQLBuilder.Core -Version 1.0.4.9
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Zq.SQLBuilder.Core" Version="1.0.4.9" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Zq.SQLBuilder.Core" Version="1.0.4.9" />
<PackageReference Include="Zq.SQLBuilder.Core" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Zq.SQLBuilder.Core --version 1.0.4.9
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Zq.SQLBuilder.Core, 1.0.4.9"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Zq.SQLBuilder.Core@1.0.4.9
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Zq.SQLBuilder.Core&version=1.0.4.9
#tool nuget:?package=Zq.SQLBuilder.Core&version=1.0.4.9
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Expression表达式转换为SQL语句，支持SqlServer、MySQL、Oracle、SQLite、PostgreSQL；基于Dapper实现了不同数据库对应的数据仓储Repository；
| 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. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.0
- Dapper (>= 2.0.35)
- Microsoft.CSharp (>= 4.7.0)
- Microsoft.Data.Sqlite (>= 3.1.6)
- Microsoft.Extensions.Configuration.Json (>= 3.1.6)
- Microsoft.Extensions.DependencyInjection (>= 3.1.6)
- Microsoft.Extensions.Options.ConfigurationExtensions (>= 3.1.6)
- MySql.Data (>= 8.0.21)
- Npgsql (>= 4.1.3.1)
- Oracle.ManagedDataAccess.Core (>= 2.19.80)
- System.ComponentModel.Annotations (>= 4.7.0)
- System.Data.Common (>= 4.3.0)
- System.Data.SqlClient (>= 4.8.1)
NuGet packages (7)
Showing the top 5 NuGet packages that depend on Zq.SQLBuilder.Core:
| Package | Downloads |
|---|---|
|
Zq.SQLBuilder.Core.ElasticApm
ElasticApm扩展，实现sql链路追踪； |
|
|
Zq.SQLBuilder.Core.SkyWalking
SkyWalking扩展，实现sql链路追踪； |
|
|
Zq.SQLBuilder.Core.Diagnostics
SqlBuilder自定义Diagnostics扩展，实现sql自定义追踪监控； |
|
|
Ydhp.Lib.Dapper
Package Description |
|
|
Peak.Lib.Dapper
Package Description |
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 2.4.0 | 1,589 | 2/19/2023 |
| 2.3.9 | 1,815 | 9/12/2022 |
| 2.3.8 | 1,950 | 5/15/2022 |
| 2.3.7 | 1,891 | 5/14/2022 |
| 2.3.6 | 1,861 | 5/7/2022 |
| 2.3.5 | 2,142 | 4/4/2022 |
| 2.3.4 | 2,003 | 3/29/2022 |
| 2.3.3 | 1,976 | 3/24/2022 |
| 2.3.2 | 1,970 | 3/21/2022 |
| 2.3.1 | 1,509 | 12/31/2021 |
| 2.3.0 | 1,215 | 12/30/2021 |
| 2.2.9 | 1,151 | 12/27/2021 |
| 2.2.8 | 1,560 | 11/9/2021 |
| 2.2.7 | 1,288 | 10/17/2021 |
| 2.2.6 | 1,279 | 9/17/2021 |
| 2.2.5 | 1,235 | 7/10/2021 |
| 2.2.4 | 1,170 | 6/25/2021 |
| 2.2.3 | 1,267 | 6/23/2021 |
| 2.2.2 | 1,213 | 6/15/2021 |
| 2.2.1 | 1,242 | 6/6/2021 |
| 2.2.0 | 1,107 | 6/1/2021 |
| 2.1.9 | 1,183 | 5/13/2021 |
| 2.1.8 | 1,206 | 4/15/2021 |
| 2.1.7 | 1,109 | 4/14/2021 |
| 2.1.6 | 1,221 | 4/8/2021 |
| 2.1.5 | 1,138 | 1/20/2021 |
| 2.1.4 | 748 | 1/14/2021 |
| 2.1.3 | 833 | 1/1/2021 |
| 2.1.2 | 1,011 | 11/15/2020 |
| 2.1.1 | 874 | 11/12/2020 |
| 2.1.0 | 795 | 11/11/2020 |
| 2.0.5 | 775 | 11/10/2020 |
| 2.0.4 | 814 | 11/9/2020 |
| 2.0.3 | 608 | 11/5/2020 |
| 2.0.2 | 598 | 11/5/2020 |
| 2.0.1 | 744 | 10/31/2020 |
| 2.0.0 | 664 | 10/30/2020 |
| 1.0.6.7 | 622 | 10/27/2020 |
| 1.0.6.6 | 680 | 10/23/2020 |
| 1.0.6.5 | 619 | 10/22/2020 |
| 1.0.6.4 | 618 | 10/16/2020 |
| 1.0.6.3 | 624 | 10/13/2020 |
| 1.0.6.2 | 655 | 10/13/2020 |
| 1.0.6.1 | 616 | 10/12/2020 |
| 1.0.6 | 674 | 9/30/2020 |
| 1.0.5.9 | 636 | 9/29/2020 |
| 1.0.5.8 | 828 | 9/19/2020 |
| 1.0.5.7 | 780 | 9/17/2020 |
| 1.0.5.6 | 938 | 8/14/2020 |
| 1.0.5.5 | 699 | 8/11/2020 |
| 1.0.5.4 | 736 | 8/11/2020 |
| 1.0.5.3 | 696 | 8/3/2020 |
| 1.0.5.2 | 720 | 8/1/2020 |
| 1.0.5.1 | 705 | 7/31/2020 |
| 1.0.5 | 648 | 7/24/2020 |
| 1.0.4.9 | 677 | 7/16/2020 |
| 1.0.4.8 | 760 | 6/10/2020 |
| 1.0.4.7 | 684 | 5/27/2020 |
| 1.0.4.6 | 670 | 5/9/2020 |
| 1.0.4.5 | 884 | 4/11/2020 |
| 1.0.4.4 | 730 | 4/10/2020 |
| 1.0.4.3 | 787 | 4/9/2020 |
| 1.0.4.2 | 725 | 4/2/2020 |
| 1.0.4.1 | 754 | 4/2/2020 |
| 1.0.4 | 821 | 3/31/2020 |
| 1.0.3.9 | 717 | 3/30/2020 |
| 1.0.3.8 | 750 | 3/29/2020 |
| 1.0.3.7 | 742 | 3/29/2020 |
| 1.0.3.6 | 801 | 3/23/2020 |
| 1.0.3.5 | 740 | 3/12/2020 |
| 1.0.3.4 | 824 | 12/30/2019 |
| 1.0.3.3 | 763 | 12/30/2019 |
| 1.0.3.2 | 795 | 12/5/2019 |
| 1.0.3.1 | 762 | 12/5/2019 |
| 1.0.3 | 784 | 10/8/2019 |
| 1.0.2.9 | 884 | 7/15/2019 |
| 1.0.2.8 | 730 | 7/13/2019 |
| 1.0.2.7 | 819 | 5/31/2019 |
| 1.0.2.6 | 800 | 5/24/2019 |
| 1.0.2.5 | 778 | 5/15/2019 |
| 1.0.2.2 | 815 | 4/26/2019 |
| 1.0.2.1 | 833 | 3/7/2019 |
| 1.0.2 | 1,030 | 9/27/2018 |
| 1.0.1.9 | 1,066 | 9/17/2018 |
| 1.0.1.7 | 1,006 | 9/14/2018 |
| 1.0.1.6 | 1,100 | 9/10/2018 |
| 1.0.1.5 | 1,095 | 9/10/2018 |
| 1.0.1.4 | 1,041 | 9/9/2018 |
| 1.0.1.3 | 1,137 | 9/5/2018 |
| 1.0.1.2 | 1,048 | 9/1/2018 |
| 1.0.1.1 | 1,063 | 9/1/2018 |
| 1.0.1 | 1,151 | 8/24/2018 |
| 1.0.0.9 | 1,119 | 8/24/2018 |
| 1.0.0.8 | 1,088 | 8/24/2018 |
| 1.0.0.7 | 1,122 | 8/10/2018 |
| 1.0.0.6 | 1,136 | 8/10/2018 |
| 1.0.0.5 | 1,195 | 8/9/2018 |
| 1.0.0.4 | 1,125 | 8/8/2018 |
| 1.0.0.3 | 1,037 | 8/8/2018 |
| 1.0.0.2 | 1,062 | 8/8/2018 |
| 1.0.0.1 | 1,062 | 8/8/2018 |
| 1.0.0 | 1,149 | 8/8/2018 |
1.新增Linq扩展方法WhereIF；
2.重载Where、AndWhere和OrWhere方法；
3.新增WhereIF方法；
4.修改表变量，添加格式化；
5.重载Join、InnerJoin、LeftJoin、RightJoin和FullJoin方法，支持自定义Join拼接sql语句；