SmartSql.ZooKeeperConfig
3.7.16
.NET Standard 2.0
.NET Framework 4.6
Install-Package SmartSql.ZooKeeperConfig -Version 3.7.16
dotnet add package SmartSql.ZooKeeperConfig --version 3.7.16
<PackageReference Include="SmartSql.ZooKeeperConfig" Version="3.7.16" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SmartSql.ZooKeeperConfig --version 3.7.16
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SmartSql.ZooKeeperConfig, 3.7.16"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install SmartSql.ZooKeeperConfig as a Cake Addin
#addin nuget:?package=SmartSql.ZooKeeperConfig&version=3.7.16
// Install SmartSql.ZooKeeperConfig as a Cake Tool
#tool nuget:?package=SmartSql.ZooKeeperConfig&version=3.7.16
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
简介
Why
- 拥抱 跨平台 DotNet Core,是时候了。
- 高性能、高生产力,超轻量级的ORM。107kb
So SmartSql
- TargetFrameworks: .NETFramework 4.6 & .NETStandard 2.0
- SmartSql = MyBatis + Cache(Memory | Redis) + ZooKeeper + R/W Splitting + ......
主要特性
- 1 ORM
- 1.1 Sync
- 1.2 Async
- 2 XmlConfig & XmlStatement → Sql
- 2.1 SmartSqlMapConfig & SmartSqlMap (是的,你猜对了,和MyBatis一样,通过XML配置分离SQL。)
- 2.2 Config Hot Update →ConfigWatcher & Reload (配置文件热更新:当你需要修改Sql的时候,直接修改SqlMap配置文件,保存即可。)
- 3 读写分离
- 3.1 读写分离
- 3.2 多读库 权重筛选 (配置多读库,根据读库权重选举读库)
- 4 日志
- 4.1 基于 Microsoft.Extensions.Logging.Abstractions (当你需要跟踪调试的时候一切都是那么一目了然)
- 5 Dynamic Repository
- 5.1 SmartSql.DyRepository (解放你的双手,你来定义仓储接口,我来实现数据库访问)
- 6 查询缓存 (热数据缓存,一个配置轻松搞定)
- 6.1 SmartSql.Cache.Memory
- 6.1.1 Fifo
- 6.1.2 Lru
- 6.2 SmartSql.Cache.Redis
- 6.3 缓存事务一致性
- 6.1 SmartSql.Cache.Memory
- 7 分布式配置插件
- 7.1 IConfigLoader (配置文件加载器)
- 7.2 LocalFileConfigLoader (本地文件配置加载器)
- 7.2.1 Load SmartSqlMapSource Xml
- 7.3.1 Load SmartSqlMapSource Directory
- 7.3 SmartSql.ZooKeeperConfig (ZooKeeper 分布式配置文件加载器)
安装 (NuGet)
Install-Package SmartSql
最佳实践
安装 SmartSql.DIExtension
Install-Package SmartSql.DIExtension
注入依赖
services.AddSmartSql();
services.AddRepositoryFactory();
services.AddRepositoryFromAssembly((options) =>
{
options.AssemblyString = "SmartSql.Starter.Repository";
});
定义仓储接口
/// <summary>
/// 属性可选: [SqlMap(Scope = "User")] ,不设置 则默认 Scope 模板:I{Scope}Repository
/// 可传入自定义模板
/// RepositoryBuilder builder=new RepositoryBuilder("I{Scope}DAL");
/// </summary>
public interface IUserRepository
{
/// <summary>
/// 属性可选 [Statement(Execute = ExecuteBehavior.Auto,Id = "Query")]
/// 默认 Execute:Auto ,自动判断 执行类型
/// 默认 Id : 方法名
/// </summary>
/// <param name="reqParams"></param>
/// <returns></returns>
IEnumerable<User> Query(object reqParams);
long GetRecord(object reqParams);
User Get(object reqParams);
long Insert(User entity);
int Update(User entity);
int Delete(User enttiy);
}
尽情享用
public class UserService
{
private readonly ISmartSqlMapper _smartSqlMapper;
private readonly IUserRepository _userRepository;
public UserService(
ISmartSqlMapper smartSqlMapper
, IUserRepository userRepository)
{
_smartSqlMapper = smartSqlMapper;
_userRepository = userRepository;
}
public long Add(AddRequest request)
{
int existsNum = _userRepository.Exists(new { request.UserName });
if (existsNum > 0)
{
throw new ArgumentException($"{nameof(request.UserName)} has already existed!");
}
return _userRepository.Add(new Entitiy.User
{
UserName = request.UserName,
Password = request.Password,
Status = Entitiy.UserStatus.Ok,
CreationTime = DateTime.Now,
});
}
public void UseTransaction()
{
try
{
_smartSqlMapper.BeginTransaction();
//Biz();
_smartSqlMapper.CommitTransaction();
}
catch (Exception ex)
{
_smartSqlMapper.RollbackTransaction();
throw ex;
}
}
}
文档地址
技术交流
点击链接加入QQ群【SmartSql 官方交流群】:604762592
Product | Versions |
---|---|
.NET | net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows |
.NET Core | netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1 |
.NET Standard | netstandard2.0 netstandard2.1 |
.NET Framework | net46 net461 net462 net463 net47 net471 net472 net48 |
MonoAndroid | monoandroid |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen40 tizen60 |
Xamarin.iOS | xamarinios |
Xamarin.Mac | xamarinmac |
Xamarin.TVOS | xamarintvos |
Xamarin.WatchOS | xamarinwatchos |
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.
-
.NETFramework 4.6
- SmartSql (>= 3.7.16)
- ZooKeeperNetEx (>= 3.4.12)
-
.NETStandard 2.0
- SmartSql (>= 3.7.16)
- ZooKeeperNetEx (>= 3.4.12)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
1. adapt SmartSql V3.7.16