SmartSql.ZooKeeperConfig 3.0.0-rc6

This is a prerelease version of SmartSql.ZooKeeperConfig.
There is a newer version of this package available.
See the version list below for details.
Install-Package SmartSql.ZooKeeperConfig -Version 3.0.0-rc6
dotnet add package SmartSql.ZooKeeperConfig --version 3.0.0-rc6
<PackageReference Include="SmartSql.ZooKeeperConfig" Version="3.0.0-rc6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SmartSql.ZooKeeperConfig --version 3.0.0-rc6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SmartSql.ZooKeeperConfig, 3.0.0-rc6"
#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.0.0-rc6&prerelease

// Install SmartSql.ZooKeeperConfig as a Cake Tool
#tool nuget:?package=SmartSql.ZooKeeperConfig&version=3.0.0-rc6&prerelease
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

简介

0. Why

  • 拥抱 跨平台 DotNet Core,是时候了。
  • 把你的双手从数据访问层解放出来,少加点班吧。

1. So SmartSql

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

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

  • 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 缓存事务一致性
  • 7 分布式配置插件
    • 7.1 IConfigLoader √ (配置文件加载器)
    • 7.2 LocalFileConfigLoader √ √ (本地文件配置加载器)
      • 7.2.1 Load SmartSqlMapSource Xml √
      • 7.3.1 Load SmartSqlMapSource Directory √
    • 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 cores
Frequency=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

ORM Type Method Mean Error StdDev Rank Gen 0 Gen 1 Gen 2 Allocated
SmartSql SmartSqlBenchmarks Query 101.6 ms 0.2226 ms 0.1738 ms 1 2437.5000 1062.5000 375.0000 13.37 MB
Native NativeBenchmarks Query_IsDBNull_GetValue 101.7 ms 0.4101 ms 0.3635 ms 1 2437.5000 1062.5000 375.0000 13.37 MB
Dapper DapperBenchmarks Query 104.4 ms 1.3195 ms 1.2342 ms 2 3375.0000 1375.0000 625.0000 17.64 MB
SmartSqlDapper SmartSqlDapperBenchmarks Query 105.7 ms 1.1697 ms 1.0941 ms 3 3750.0000 1437.5000 625.0000 19.47 MB
Native NativeBenchmarks Query_GetValue_DbNull 107.4 ms 1.0710 ms 1.0018 ms 4 3062.5000 1187.5000 500.0000 16.42 MB
SqlSugar SqlSugarBenchmarks Query 108.9 ms 0.4048 ms 0.3787 ms 5 2375.0000 1000.0000 312.5000 13.09 MB
EF EFBenchmarks SqlQuery 110.9 ms 0.6922 ms 0.6475 ms 6 11062.5000 - - 34.13 MB
Chloe ChloeBenchmarks Query 14.5 ms 2.2600 ms 5.3711 ms 7 2375.0000 1000.0000 312.5000 13.07 MB
EF EFBenchmarks Query_NoTracking 126.4 ms 1.3197 ms 1.2344 ms 8 5937.5000 2250.0000 1062.5000 30.16 MB
EF EFBenchmarks SqlQuery_NoTracking 148.6 ms 0.8290 ms 0.7755 ms 9 7437.5000 2937.5000 1250.0000 37.79 MB

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. 文档地址

8. 技术交流

点击链接加入QQ群【SmartSql 官方交流群】:604762592

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.7.16 491 10/26/2018
3.0.0 572 6/2/2018
3.0.0-rc6 485 5/28/2018
3.0.0-pre8 476 5/15/2018
1.2.8 593 3/13/2018
1.2.0 609 12/4/2017
1.1.8 683 5/25/2017
1.1.2 648 5/23/2017
1.1.0 649 5/22/2017
1.0.1 665 5/22/2017