zq-myget - Zq.SQLBuilder.Core 2.3.8

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

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

Copy to clipboard

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

Copy to clipboard

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

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

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

> choco install Zq.SQLBuilder.Core --version 2.3.8 --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.8" -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.优化WHERE是否包含判断； 2.新增SubstringIgnoreCase扩展方法； 3.优化字符串忽略大小写相等比较； 4.优化null空值判断，修复WhereIf参数Expression<T,bool>为null时引发的空异常bug； 5.升级nuget包；

  • .NETFramework 5.0
    • Dapper (>= 2.0.123)
    • Microsoft.Data.SqlClient (>= 4.1.0)
    • Microsoft.Data.Sqlite (>= 6.0.5)
    • 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.4)
    • Oracle.ManagedDataAccess.Core (>= 3.21.61)
    • 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.5)
    • 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.4)
    • Oracle.ManagedDataAccess.Core (>= 3.21.61)
    • 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.5)
    • 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.4)
    • Oracle.ManagedDataAccess.Core (>= 3.21.61)
    • 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

1 total downloads
0 downloads for version 2.3.8
Download (422.2 KB)
Download symbols (128.71 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 0
2.3.9.1 466.19 KB Tue, 13 Sep 2022 08:42:41 GMT 1
2.3.9 464.32 KB Mon, 12 Sep 2022 03:20:56 GMT 0
2.3.8 422.2 KB Sun, 15 May 2022 09:15:58 GMT 0
2.3.7 421.49 KB Sat, 14 May 2022 00:38:19 GMT 0
2.3.6 421.29 KB Sat, 07 May 2022 08:32:57 GMT 0
2.3.5.1 421.21 KB Fri, 06 May 2022 13:26:31 GMT 0
2.3.5 422.84 KB Mon, 04 Apr 2022 07:04:04 GMT 0
2.3.4.1 416.53 KB Wed, 30 Mar 2022 02:46:44 GMT 0