Expression表达式转换为SQL语句，支持SqlServer、MySql、Oracle、Sqlite、PostgreSql；基于Dapper实现了不同数据库对应的数据仓储Repository；.
Learn Dapper: https://www.learndapper.com/
Dapper Tutorial: https://dappertutorial.net/
Info
| Version: | 2.4.0 |
| Author(s): | 张强 |
| Last Update: | Sunday, February 19, 2023 |
| .NET Fiddle: | Create the first Fiddle |
| Project Url: | https://github.com/zqlovejyc/SQLBuilder.Core |
| NuGet Url: | https://www.nuget.org/packages/Zq.SQLBuilder.Core |
Install
Install-Package Zq.SQLBuilder.Core
dotnet add package Zq.SQLBuilder.Core
paket add Zq.SQLBuilder.Core
Zq.SQLBuilder.Core Download (Unzip the "nupkg" after downloading)
Dependencies
.NETStandard 2.0
- Dapper(>= 2.0.78)
- FastExpressionCompiler(>= 2.0.0)
- Microsoft.Data.SqlClient(>= 2.1.1)
- Microsoft.Data.Sqlite(>= 5.0.2)
- Microsoft.Extensions.Configuration.Json(>= 5.0.0)
- Microsoft.Extensions.DependencyInjection(>= 5.0.1)
- Microsoft.Extensions.Options.ConfigurationExtensions(>= 5.0.0)
- MySqlConnector(>= 1.2.1)
- Npgsql(>= 5.0.1.1)
- Oracle.ManagedDataAccess.Core(>= 2.19.101)
- System.ComponentModel.Annotations(>= 5.0.0)
- System.Diagnostics.DiagnosticSource(>= 5.0.1)
- Dapper(>= 2.0.78)
- FastExpressionCompiler(>= 2.0.0)
- Microsoft.Data.SqlClient(>= 2.1.1)
- Microsoft.Data.Sqlite(>= 5.0.2)
- Microsoft.Extensions.Configuration.Json(>= 5.0.0)
- Microsoft.Extensions.DependencyInjection(>= 5.0.1)
- Microsoft.Extensions.Options.ConfigurationExtensions(>= 5.0.0)
- MySqlConnector(>= 1.2.1)
- Npgsql(>= 5.0.1.1)
- Oracle.ManagedDataAccess.Core(>= 2.19.101)
- System.ComponentModel.Annotations(>= 5.0.0)
- System.Diagnostics.DiagnosticSource(>= 5.0.1)
- Dapper(>= 2.0.78)
- FastExpressionCompiler(>= 2.0.0)
- Microsoft.Data.SqlClient(>= 2.1.1)
- Microsoft.Data.Sqlite(>= 5.0.2)
- Microsoft.Extensions.Configuration.Json(>= 5.0.0)
- Microsoft.Extensions.DependencyInjection(>= 5.0.1)
- Microsoft.Extensions.Options.ConfigurationExtensions(>= 5.0.0)
- MySqlConnector(>= 1.2.1)
- Npgsql(>= 5.0.1.1)
- Oracle.ManagedDataAccess.Core(>= 2.19.101)
- System.ComponentModel.Annotations(>= 5.0.0)
- System.Diagnostics.DiagnosticSource(>= 5.0.1)
Tags
