0. Why

• 拥抱 跨平台 DotNet Core，是时候了。
• 高性能、高生产力，史上最轻量级的ORM。107kb

1. So SmartSql

• TargetFrameworks: .NETFramework 4.6 & .NETStandard 2.0
• SmartSql = MyBatis + Cache(Memory | Redis) + ZooKeeper + R/W Splitting + ……

2. 主要特性 (√ 为已完成，未打 √ 为计划特性)

1. 1 ORM
2. 1.1 Sync
3. 1.2 Async
4. 2 XmlConfig & XmlStatement -> Sql
5. 2.1 SmartSqlMapConfig & SmartSqlMap √ (是的，你猜对了，和MyBatis一样，通过XML配置分离SQL。)
6. 2.2 Config Hot Update ->ConfigWatcher & Reload (配置文件热更新：当你需要修改Sql的时候，直接修改SqlMap配置文件，保存即可。)
7. 3 读写分离 √
8. 3.1 读写分离 √
9. 3.2 多读库 权重筛选 √ （配置多读库，根据读库权重选举读库）
10. 4 日志 √
11. 4.1 基于 Microsoft.Extensions.Logging.Abstractions (当你需要跟踪调试的时候一切都是那么一目了然)
12. 5 Dynamic Repository
13. 5.1 SmartSql.DyRepository √ （解放你的双手，你来定义仓储接口，我来实现数据库访问）
14. 6 查询缓存 √ （热数据缓存，一个配置轻松搞定）
15. 6.1 SmartSql.Cache.Memory √
16. 6.1.1 Fifo √
17. 6.1.2 Lru √
18. 6.2 SmartSql.Cache.Redis √
19. 6.3 缓存事务一致性
20. 7 分布式配置插件
21. 7.1 IConfigLoader √ (配置文件加载器)
22. 7.2 LocalFileConfigLoader √ √ (本地文件配置加载器)
23. 7.2.1 Load SmartSqlMapSource Xml √
24. 7.3.1 Load SmartSqlMapSource Directory √
25. 7.3 SmartSql.ZooKeeperConfig √ (ZooKeeper 分布式配置文件加载器)

3. 性能

BenchmarkDotNet=v0.10.14, OS=Windows 10.0.16299.431 (1709/FallCreatorsUpdate/Redstone3)Intel Core i7-4710MQ CPU 2.50GHz (Haswell), 1 CPU, 8 logical and 4 physical coresFrequency=2435768 Hz, Resolution=410.5481 ns, Timer=TSC.NET Core SDK=2.1.201 [Host] : .NET Core 2.0.7 (CoreCLR 4.6.26328.01, CoreFX 4.6.26403.03), 64bit RyuJIT DefaultJob : .NET Core 2.0.7 (CoreCLR 4.6.26328.01, CoreFX 4.6.26403.03), 64bit RyuJIT

4. 安装 (NuGet)

Install-Package SmartSql

5. 常规代码查询

ISmartSqlMapper SqlMapper = MapperContainer.Instance.GetSqlMapper();SqlMapper.Query<T_Test>(new RequestContext{Scope = "T_Test",SqlId = "GetList",Request = new { Ids = new long[] { 1, 2, 3, 4 } }});

事务

 try { ISmartSqlMapper SqlMapper = MapperContainer.Instance.GetSqlMapper(); SqlMapper.BeginTransaction(); //BizCode SqlMapper.CommitTransaction(); } catch (Exception ex) { SqlMapper.RollbackTransaction(); throw ex; }

6. 最佳实践

6.1 安装 SmartSql.DIExtension

Install-Package SmartSql.DIExtension

6.2 注入依赖

services.AddSmartSql(); services.AddRepositoryFactory(); services.AddRepositoryFromAssembly((options) => { options.AssemblyString = "SmartSql.Starter.Repository"; });

6.3 定义仓储接口

/// <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); }

6.4 尽情享用

 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; } } }

7. 文档地址

• 在线阅读地址
• PDF
• Mobi
• ePub

services.AddSmartSql(); services.AddRepositoryFactory(); services.AddRepositoryFromAssembly((options) => {    options.AssemblyString = "SmartSql.Starter.Repository"; });--------------------- 作者：Ahoo 来源：CSDN 原文：https://blog.csdn.net/tsgx_1989/article/details/69055089 版权声明：本文为博主原创文章，转载请附上博文链接！