Zq.SQLBuilder.Core 2.2.7

.NET 5.0 This package targets .NET 5.0. The package is compatible with this framework or higher. .NET Standard 2.1 This package targets .NET Standard 2.1. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package Zq.SQLBuilder.Core --version 2.2.7                

                    
                

            
NuGet\Install-Package Zq.SQLBuilder.Core -Version 2.2.7
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="2.2.7" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Zq.SQLBuilder.Core --version 2.2.7                

                    
                

            
#r "nuget: Zq.SQLBuilder.Core, 2.2.7"
#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. 
// Install Zq.SQLBuilder.Core as a Cake Addin
#addin nuget:?package=Zq.SQLBuilder.Core&version=2.2.7

// Install Zq.SQLBuilder.Core as a Cake Tool
#tool nuget:?package=Zq.SQLBuilder.Core&version=2.2.7

Expression表达式转换为SQL语句，支持SqlServer、MySql、Oracle、Sqlite、PostgreSql；基于Dapper实现了不同数据库对应的数据仓储Repository；

Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  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. 
.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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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,356 2/19/2023
2.3.9 1,775 9/12/2022
2.3.8 1,897 5/15/2022
2.3.7 1,842 5/14/2022
2.3.6 1,806 5/7/2022
2.3.5 2,079 4/4/2022
2.3.4 1,945 3/29/2022
2.3.3 1,923 3/24/2022
2.3.2 1,923 3/21/2022
2.3.1 1,445 12/31/2021
2.3.0 1,156 12/30/2021
2.2.9 1,098 12/27/2021
2.2.8 1,498 11/9/2021
2.2.7 1,234 10/17/2021
2.2.6 1,221 9/17/2021
2.2.5 1,176 7/10/2021
2.2.4 1,121 6/25/2021
2.2.3 1,216 6/23/2021
2.2.2 1,159 6/15/2021
2.2.1 1,181 6/6/2021
2.2.0 1,054 6/1/2021
2.1.9 1,126 5/13/2021
2.1.8 1,147 4/15/2021
2.1.7 1,056 4/14/2021
2.1.6 1,164 4/8/2021
2.1.5 1,075 1/20/2021
2.1.4 689 1/14/2021
2.1.3 760 1/1/2021
2.1.2 946 11/15/2020
2.1.1 808 11/12/2020
2.1.0 731 11/11/2020
2.0.5 712 11/10/2020
2.0.4 744 11/9/2020
2.0.3 548 11/5/2020
2.0.2 537 11/5/2020
2.0.1 682 10/31/2020
2.0.0 593 10/30/2020
1.0.6.7 560 10/27/2020
1.0.6.6 606 10/23/2020
1.0.6.5 552 10/22/2020
1.0.6.4 549 10/16/2020
1.0.6.3 558 10/13/2020
1.0.6.2 581 10/13/2020
1.0.6.1 555 10/12/2020
1.0.6 605 9/30/2020
1.0.5.9 569 9/29/2020
1.0.5.8 758 9/19/2020
1.0.5.7 713 9/17/2020
1.0.5.6 862 8/14/2020
1.0.5.5 629 8/11/2020
1.0.5.4 668 8/11/2020
1.0.5.3 622 8/3/2020
1.0.5.2 656 8/1/2020
1.0.5.1 636 7/31/2020
1.0.5 586 7/24/2020
1.0.4.9 615 7/16/2020
1.0.4.8 696 6/10/2020
1.0.4.7 615 5/27/2020
1.0.4.6 602 5/9/2020
1.0.4.5 816 4/11/2020
1.0.4.4 653 4/10/2020
1.0.4.3 713 4/9/2020
1.0.4.2 654 4/2/2020
1.0.4.1 684 4/2/2020
1.0.4 747 3/31/2020
1.0.3.9 645 3/30/2020
1.0.3.8 672 3/29/2020
1.0.3.7 669 3/29/2020
1.0.3.6 725 3/23/2020
1.0.3.5 666 3/12/2020
1.0.3.4 745 12/30/2019
1.0.3.3 694 12/30/2019
1.0.3.2 726 12/5/2019
1.0.3.1 687 12/5/2019
1.0.3 700 10/8/2019
1.0.2.9 797 7/15/2019
1.0.2.8 646 7/13/2019
1.0.2.7 742 5/31/2019
1.0.2.6 717 5/24/2019
1.0.2.5 704 5/15/2019
1.0.2.2 739 4/26/2019
1.0.2.1 754 3/7/2019
1.0.2 938 9/27/2018
1.0.1.9 960 9/17/2018
1.0.1.7 912 9/14/2018
1.0.1.6 1,004 9/10/2018
1.0.1.5 984 9/10/2018
1.0.1.4 940 9/9/2018
1.0.1.3 1,036 9/5/2018
1.0.1.2 942 9/1/2018
1.0.1.1 962 9/1/2018
1.0.1 1,053 8/24/2018
1.0.0.9 1,020 8/24/2018
1.0.0.8 981 8/24/2018
1.0.0.7 1,014 8/10/2018
1.0.0.6 1,036 8/10/2018
1.0.0.5 1,086 8/9/2018
1.0.0.4 968 8/8/2018
1.0.0.3 874 8/8/2018
1.0.0.2 905 8/8/2018
1.0.0.1 903 8/8/2018
1.0.0 985 8/8/2018

1.优化ConfigurationManager，支持appsettings自定义环境变量“APPSETTINGS_ENVIRONMENT”；
2.优化仓储构造函数，添加“configuration”可选参数，用于支持自定义IConfiguration；
3.重命名SetConfigurationFile -> SetConfiguration，重载SetConfiguration；
4.新增FormattableString扩展类；
5.重载IRepository部分接口并实现，支持FormattableString内插sql语句；
6.移除IRepository的Close方法，以Dispose方法替代；新增AutoDispose属性、UseAutoDispose方法；
7.优化仓储数据库连接释放逻辑，支持共享连接模式；
8.优化AddSqlBuilder扩展，新增AddRepository、AddAllRepository、GetConnectionInformation、CreateRepositoryFactory扩展方法；
9.升级nuget依赖引用包到最新版本；