zq-myget - Zq.SQLBuilder.Core 2.3.5

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

PM> Install-Package Zq.SQLBuilder.Core -Version 2.3.5 -Source https://www.myget.org/F/zq-myget/api/v3/index.json

Copy to clipboard

> nuget.exe install Zq.SQLBuilder.Core -Version 2.3.5 -Source https://www.myget.org/F/zq-myget/api/v3/index.json

Copy to clipboard

> dotnet add package Zq.SQLBuilder.Core --version 2.3.5 --source https://www.myget.org/F/zq-myget/api/v3/index.json

Copy to clipboard
<PackageReference Include="Zq.SQLBuilder.Core" Version="2.3.5" />
Copy to clipboard
source https://www.myget.org/F/zq-myget/api/v3/index.json

nuget Zq.SQLBuilder.Core  ~> 2.3.5
Copy to clipboard

> choco install Zq.SQLBuilder.Core --version 2.3.5 --source https://www.myget.org/F/zq-myget/api/v2

Copy to clipboard
Import-Module PowerShellGet
Register-PSRepository -Name "zq-myget" -SourceLocation "https://www.myget.org/F/zq-myget/api/v2"
Install-Module -Name "Zq.SQLBuilder.Core" -RequiredVersion "2.3.5" -Repository "zq-myget" 
Copy to clipboard

Browse the sources in this package using Visual Studio or WinDbg by configuring the following symbol server URL: https://www.myget.org/F/zq-myget/api/v2/symbolpackage/


1.优化SqlBuilderCore部分属性; 2.优化GetKeyWordIndex; 3.优化字典初始化和取值判断; 4.移除OracleColumnAttribute和Oracle插入更新扩展,采用DataTypeAttribute特性进行替代即可; 5.优化GetColumnInfo和GetPrimaryKey返回类型; 6.KeyAttribute特性新增OracleSequenceName; 7.重载仓储Insert,支持返回自增主键值;

  • .NETFramework 5.0
    • Dapper (>= 2.0.123)
    • Microsoft.Data.SqlClient (>= 4.1.0)
    • Microsoft.Data.Sqlite (>= 6.0.3)
    • Microsoft.Extensions.Configuration.Json (>= 6.0.0)
    • Microsoft.Extensions.DependencyInjection (>= 6.0.0)
    • Microsoft.Extensions.Options.ConfigurationExtensions (>= 6.0.0)
    • MySqlConnector (>= 2.1.8)
    • Newtonsoft.Json (>= 13.0.1)
    • Npgsql (>= 6.0.3)
    • Oracle.ManagedDataAccess.Core (>= 3.21.50)
    • System.ComponentModel.Annotations (>= 5.0.0)
    • System.Diagnostics.DiagnosticSource (>= 6.0.0)
  • .NETFramework 6.0
    • Dapper (>= 2.0.123)
    • Microsoft.Data.SqlClient (>= 4.1.0)
    • Microsoft.Data.Sqlite (>= 6.0.3)
    • Microsoft.Extensions.Configuration.Json (>= 6.0.0)
    • Microsoft.Extensions.DependencyInjection (>= 6.0.0)
    • Microsoft.Extensions.Options.ConfigurationExtensions (>= 6.0.0)
    • MySqlConnector (>= 2.1.8)
    • Newtonsoft.Json (>= 13.0.1)
    • Npgsql (>= 6.0.3)
    • Oracle.ManagedDataAccess.Core (>= 3.21.50)
    • System.ComponentModel.Annotations (>= 5.0.0)
    • System.Diagnostics.DiagnosticSource (>= 6.0.0)
  • .NETStandard 2.1
    • Dapper (>= 2.0.123)
    • Microsoft.Data.SqlClient (>= 4.1.0)
    • Microsoft.Data.Sqlite (>= 6.0.3)
    • Microsoft.Extensions.Configuration.Json (>= 6.0.0)
    • Microsoft.Extensions.DependencyInjection (>= 6.0.0)
    • Microsoft.Extensions.Options.ConfigurationExtensions (>= 6.0.0)
    • MySqlConnector (>= 2.1.8)
    • Newtonsoft.Json (>= 13.0.1)
    • Npgsql (>= 6.0.3)
    • Oracle.ManagedDataAccess.Core (>= 3.21.50)
    • System.ComponentModel.Annotations (>= 5.0.0)
    • System.Diagnostics.DiagnosticSource (>= 6.0.0)
  • .NETFramework 5.0: 5.0.0.0
  • .NETFramework 6.0: 6.0.0.0
  • .NETStandard 2.1: 2.1.0.0

Owners

zqlovejyc

Authors

张强

Project URL

https://github.com/zqlovejyc/SQLBuilder.Core

License

Unknown

Tags

sqlbuilder expression repository sql orm dapper

Info

758 total downloads
78 downloads for version 2.3.5
Download (422.84 KB)
Download symbols (127.99 KB)
Found on the current feed only

Package history

Version Size Last updated Downloads Mirrored?
2.4.0 623.29 KB Sun, 19 Feb 2023 09:37:20 GMT 89
2.3.9.1 466.19 KB Tue, 13 Sep 2022 08:42:41 GMT 84
2.3.9 464.32 KB Mon, 12 Sep 2022 03:20:56 GMT 87
2.3.8 422.2 KB Sun, 15 May 2022 09:15:58 GMT 77
2.3.7 421.49 KB Sat, 14 May 2022 00:38:19 GMT 86
2.3.6 421.29 KB Sat, 07 May 2022 08:32:57 GMT 81
2.3.5.1 421.21 KB Fri, 06 May 2022 13:26:31 GMT 88
2.3.5 422.84 KB Mon, 04 Apr 2022 07:04:04 GMT 78
2.3.4.1 416.53 KB Wed, 30 Mar 2022 02:46:44 GMT 88