Zq.SQLBuilder
2.3.6
.NET Framework 4.5
dotnet add package Zq.SQLBuilder --version 2.3.6
NuGet\Install-Package Zq.SQLBuilder -Version 2.3.6
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" Version="2.3.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Zq.SQLBuilder --version 2.3.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Zq.SQLBuilder, 2.3.6"
#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 as a Cake Addin
#addin nuget:?package=Zq.SQLBuilder&version=2.3.6
// Install Zq.SQLBuilder as a Cake Tool
#tool nuget:?package=Zq.SQLBuilder&version=2.3.6
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 |
---|---|
.NET Framework | net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48 net481 |
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.
-
.NETFramework 4.5
- Autofac (>= 4.9.4)
- Dapper (>= 1.50.2)
- MySqlConnector (>= 2.1.13)
- Newtonsoft.Json (>= 13.0.1)
- Npgsql (>= 4.0.12)
- Oracle.ManagedDataAccess (>= 19.12.0)
- Stub.System.Data.SQLite.Core.NetFramework (>= 1.0.116)
- System.Buffers (>= 4.5.1)
- System.Data.SQLite.Core (>= 1.0.116)
- System.Diagnostics.DiagnosticSource (>= 5.0.1)
- System.Memory (>= 4.5.5)
- System.Runtime.CompilerServices.Unsafe (>= 5.0.0)
- System.Threading.Tasks.Extensions (>= 4.5.4)
- System.ValueTuple (>= 4.5.0)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on Zq.SQLBuilder:
Package | Downloads |
---|---|
Zq.SQLBuilder.Diagnostics
SqlBuilder的日志诊断订阅扩展类; |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
2.3.6 | 291 | 9/12/2022 |
2.3.5 | 329 | 5/15/2022 |
2.3.4 | 284 | 5/14/2022 |
2.3.3 | 288 | 5/7/2022 |
2.3.2 | 318 | 4/4/2022 |
2.3.1 | 301 | 3/29/2022 |
2.3.0 | 305 | 3/25/2022 |
2.2.9 | 283 | 3/24/2022 |
2.2.8 | 286 | 3/24/2022 |
2.2.7 | 290 | 3/21/2022 |
2.2.6 | 259 | 12/31/2021 |
2.2.5 | 197 | 12/30/2021 |
2.2.4 | 192 | 12/27/2021 |
2.2.3 | 433 | 11/20/2021 |
2.2.2 | 283 | 11/9/2021 |
2.2.1 | 276 | 10/17/2021 |
2.2.0 | 264 | 9/17/2021 |
2.1.9 | 373 | 7/10/2021 |
2.1.8 | 274 | 6/25/2021 |
2.1.7 | 264 | 6/23/2021 |
2.1.6 | 298 | 6/15/2021 |
2.1.5 | 334 | 6/6/2021 |
2.1.4 | 322 | 6/1/2021 |
2.1.3 | 291 | 5/13/2021 |
2.1.2 | 266 | 4/15/2021 |
2.1.1 | 264 | 4/14/2021 |
2.1.0 | 362 | 1/20/2021 |
2.0.9 | 349 | 1/14/2021 |
2.0.8 | 378 | 1/1/2021 |
2.0.7 | 550 | 11/15/2020 |
2.0.6 | 371 | 11/12/2020 |
2.0.5 | 360 | 11/10/2020 |
2.0.4 | 348 | 11/9/2020 |
2.0.3 | 348 | 11/5/2020 |
2.0.2 | 350 | 11/5/2020 |
2.0.1 | 323 | 10/31/2020 |
2.0.0 | 408 | 10/30/2020 |
1.1.4.3 | 352 | 10/27/2020 |
1.1.4.2 | 428 | 10/23/2020 |
1.1.4.1 | 345 | 10/22/2020 |
1.1.4 | 387 | 10/17/2020 |
1.1.3.9 | 335 | 10/13/2020 |
1.1.3.8 | 349 | 10/13/2020 |
1.1.3.7 | 375 | 10/12/2020 |
1.1.3.6 | 394 | 9/30/2020 |
1.1.3.5 | 347 | 9/29/2020 |
1.1.3.4 | 480 | 9/19/2020 |
1.1.3.3 | 387 | 9/17/2020 |
1.1.3.2 | 459 | 8/14/2020 |
1.1.3.1 | 367 | 8/11/2020 |
1.1.3 | 422 | 8/11/2020 |
1.1.2.9 | 398 | 8/3/2020 |
1.1.2.8 | 348 | 8/1/2020 |
1.1.2.7 | 436 | 7/31/2020 |
1.1.2.6 | 393 | 7/24/2020 |
1.1.2.5 | 377 | 7/16/2020 |
1.1.2.4 | 370 | 6/10/2020 |
1.1.2.3 | 399 | 5/27/2020 |
1.1.2.2 | 420 | 5/9/2020 |
1.1.2.1 | 550 | 4/11/2020 |
1.1.2 | 514 | 4/10/2020 |
1.1.1.9 | 521 | 4/9/2020 |
1.1.1.8 | 501 | 4/2/2020 |
1.1.1.7 | 479 | 3/31/2020 |
1.1.1.6 | 418 | 3/30/2020 |
1.1.1.5 | 434 | 3/29/2020 |
1.1.1.4 | 505 | 3/23/2020 |
1.1.1.3 | 438 | 3/12/2020 |
1.1.1.2 | 484 | 12/30/2019 |
1.1.1.1 | 447 | 12/30/2019 |
1.1.1 | 498 | 12/5/2019 |
1.1.0.9 | 434 | 12/5/2019 |
1.1.0.8 | 547 | 10/8/2019 |
1.1.0.7 | 551 | 7/15/2019 |
1.1.0.6 | 464 | 7/13/2019 |
1.1.0.5 | 448 | 7/13/2019 |
1.1.0.4 | 501 | 5/31/2019 |
1.1.0.3 | 494 | 5/24/2019 |
1.1.0.2 | 470 | 5/15/2019 |
1.0.9.8 | 522 | 4/26/2019 |
1.0.9.7 | 552 | 3/7/2019 |
1.0.9.6 | 752 | 9/27/2018 |
1.0.9.5 | 675 | 9/17/2018 |
1.0.9.3 | 693 | 9/14/2018 |
1.0.9.2 | 731 | 9/10/2018 |
1.0.9.1 | 663 | 9/10/2018 |
1.0.9 | 680 | 9/9/2018 |
1.0.8.9 | 722 | 9/5/2018 |
1.0.8.8 | 799 | 8/24/2018 |
1.0.8.7 | 708 | 8/24/2018 |
1.0.8.6 | 695 | 8/24/2018 |
1.0.8.5 | 847 | 8/9/2018 |
1.0.8.4 | 747 | 8/3/2018 |
1.0.8.3 | 732 | 8/3/2018 |
1.0.8.2 | 752 | 8/3/2018 |
1.0.8.1 | 730 | 8/3/2018 |
1.0.8 | 716 | 8/2/2018 |
1.0.7.9 | 729 | 7/31/2018 |
1.0.7.8 | 712 | 7/29/2018 |
1.0.7.7 | 745 | 7/28/2018 |
1.0.7.6 | 722 | 7/28/2018 |
1.0.7.5 | 720 | 7/27/2018 |
1.0.7.4 | 724 | 7/27/2018 |
1.0.7.3 | 756 | 7/25/2018 |
1.0.7.2 | 756 | 7/24/2018 |
1.0.7.1 | 707 | 7/24/2018 |
1.0.7 | 715 | 7/23/2018 |
1.0.6.9 | 785 | 7/19/2018 |
1.0.6.8 | 848 | 7/10/2018 |
1.0.6.7 | 845 | 7/10/2018 |
1.0.6.6 | 800 | 7/9/2018 |
1.0.6.5 | 818 | 7/9/2018 |
1.0.6.4 | 825 | 7/9/2018 |
1.0.6.3 | 811 | 7/9/2018 |
1.0.6.2 | 814 | 7/8/2018 |
1.0.6.1 | 791 | 7/8/2018 |
1.0.6 | 814 | 7/8/2018 |
1.0.5.9 | 789 | 7/6/2018 |
1.0.5.8 | 823 | 7/5/2018 |
1.0.5.7 | 843 | 7/5/2018 |
1.0.5.6 | 766 | 7/4/2018 |
1.0.5.5 | 809 | 7/4/2018 |
1.0.5.4 | 757 | 7/3/2018 |
1.0.5.3 | 822 | 7/3/2018 |
1.0.5.2 | 738 | 7/3/2018 |
1.0.5.1 | 818 | 7/2/2018 |
1.0.5 | 874 | 7/2/2018 |
1.0.4.9 | 723 | 7/2/2018 |
1.0.4.8 | 885 | 7/1/2018 |
1.0.4.7 | 755 | 5/22/2018 |
1.0.4.6 | 889 | 5/14/2018 |
1.0.4.5 | 889 | 5/13/2018 |
1.0.4.4 | 966 | 5/6/2018 |
1.0.4.3 | 890 | 5/6/2018 |
1.0.3 | 932 | 5/1/2018 |
1.0.2 | 851 | 4/25/2018 |
1.引入FastMember,替换原有的反射调用;
2.优化GetColumnInfo、GetPrimaryKey;
3.优化ToEntities、ToLists;
4.新增TryGetValue、TryGetOrAdd、ContainsKey、ToEntity字典扩展方法;
5.优化列信息获取,添加内存缓存;
6.支持Where表达式中HashSet写法解析;
7.升级nuget包;