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. 
.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,283 2/19/2023
2.3.9 1,755 9/12/2022
2.3.8 1,882 5/15/2022
2.3.7 1,829 5/14/2022
2.3.6 1,794 5/7/2022
2.3.5 2,067 4/4/2022
2.3.4 1,933 3/29/2022
2.3.3 1,911 3/24/2022
2.3.2 1,912 3/21/2022
2.3.1 1,424 12/31/2021
2.3.0 1,144 12/30/2021
2.2.9 1,087 12/27/2021
2.2.8 1,484 11/9/2021
2.2.7 1,222 10/17/2021
2.2.6 1,207 9/17/2021
2.2.5 1,164 7/10/2021
2.2.4 1,107 6/25/2021
2.2.3 1,204 6/23/2021
2.2.2 1,147 6/15/2021
2.2.1 1,170 6/6/2021
2.2.0 1,042 6/1/2021
2.1.9 1,113 5/13/2021
2.1.8 1,134 4/15/2021
2.1.7 1,044 4/14/2021
2.1.6 1,150 4/8/2021
2.1.5 1,064 1/20/2021
2.1.4 675 1/14/2021
2.1.3 749 1/1/2021
2.1.2 934 11/15/2020
2.1.1 797 11/12/2020
2.1.0 720 11/11/2020
2.0.5 701 11/10/2020
2.0.4 732 11/9/2020
2.0.3 536 11/5/2020
2.0.2 525 11/5/2020
2.0.1 669 10/31/2020
2.0.0 580 10/30/2020
1.0.6.7 549 10/27/2020
1.0.6.6 594 10/23/2020
1.0.6.5 539 10/22/2020
1.0.6.4 537 10/16/2020
1.0.6.3 547 10/13/2020
1.0.6.2 568 10/13/2020
1.0.6.1 544 10/12/2020
1.0.6 592 9/30/2020
1.0.5.9 557 9/29/2020
1.0.5.8 744 9/19/2020
1.0.5.7 701 9/17/2020
1.0.5.6 845 8/14/2020
1.0.5.5 616 8/11/2020
1.0.5.4 657 8/11/2020
1.0.5.3 608 8/3/2020
1.0.5.2 642 8/1/2020
1.0.5.1 621 7/31/2020
1.0.5 573 7/24/2020
1.0.4.9 603 7/16/2020
1.0.4.8 682 6/10/2020
1.0.4.7 603 5/27/2020
1.0.4.6 590 5/9/2020
1.0.4.5 800 4/11/2020
1.0.4.4 642 4/10/2020
1.0.4.3 701 4/9/2020
1.0.4.2 642 4/2/2020
1.0.4.1 671 4/2/2020
1.0.4 734 3/31/2020
1.0.3.9 634 3/30/2020
1.0.3.8 660 3/29/2020
1.0.3.7 657 3/29/2020
1.0.3.6 713 3/23/2020
1.0.3.5 653 3/12/2020
1.0.3.4 734 12/30/2019
1.0.3.3 683 12/30/2019
1.0.3.2 715 12/5/2019
1.0.3.1 676 12/5/2019
1.0.3 688 10/8/2019
1.0.2.9 783 7/15/2019
1.0.2.8 634 7/13/2019
1.0.2.7 729 5/31/2019
1.0.2.6 703 5/24/2019
1.0.2.5 693 5/15/2019
1.0.2.2 727 4/26/2019
1.0.2.1 743 3/7/2019
1.0.2 922 9/27/2018
1.0.1.9 942 9/17/2018
1.0.1.7 896 9/14/2018
1.0.1.6 988 9/10/2018
1.0.1.5 967 9/10/2018
1.0.1.4 922 9/9/2018
1.0.1.3 1,019 9/5/2018
1.0.1.2 926 9/1/2018
1.0.1.1 946 9/1/2018
1.0.1 1,036 8/24/2018
1.0.0.9 1,004 8/24/2018
1.0.0.8 964 8/24/2018
1.0.0.7 997 8/10/2018
1.0.0.6 1,020 8/10/2018
1.0.0.5 1,068 8/9/2018
1.0.0.4 954 8/8/2018
1.0.0.3 859 8/8/2018
1.0.0.2 890 8/8/2018
1.0.0.1 888 8/8/2018
1.0.0 971 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依赖引用包到最新版本；