SmartSql.DyRepository 3.3.2

SmartSql 动态代理仓储

There is a newer version of this package available.
See the version list below for details.
Install-Package SmartSql.DyRepository -Version 3.3.2
dotnet add package SmartSql.DyRepository --version 3.3.2
<PackageReference Include="SmartSql.DyRepository" Version="3.3.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SmartSql.DyRepository --version 3.3.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

简介

SmartSql-Starter

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 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.17134
Intel Core i7-6700K CPU 4.00GHz (Skylake), 1 CPU, 8 logical and 4 physical cores
.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 | Return | Mean | Error | StdDev | Rank | Gen 0 | Gen 1 | Gen 2 | Allocated |
|--------------- |------------------------- |------------------------ |-------------- |----------:|----------:|----------:|-----:|----------:|----------:|----------:|----------:|
| Native | NativeBenchmarks | Query_GetValue_DbNull | IEnumerable1 | 78.39 ms | 0.8935 ms | 0.7921 ms | 1 | 3000.0000 | 1125.0000 | 500.0000 | 15.97 MB | | SmartSql | SmartSqlBenchmarks | Query | IEnumerable1 | 78.46 ms | 0.2402 ms | 0.1875 ms | 1 | 2312.5000 | 1000.0000 | 312.5000 | 12.92 MB |
| SmartSqlDapper | SmartSqlDapperBenchmarks | Query | IEnumerable1 | 78.65 ms | 1.2094 ms | 1.1312 ms | 1 | 3687.5000 | 1437.5000 | 687.5000 | 19.03 MB | | Native | NativeBenchmarks | Query_IsDBNull_GetValue | IEnumerable1 | 78.84 ms | 0.8984 ms | 0.7502 ms | 1 | 2312.5000 | 1000.0000 | 312.5000 | 12.92 MB |
| Dapper | DapperBenchmarks | Query | IEnumerable1 | 79.00 ms | 1.0949 ms | 0.9706 ms | 1 | 3312.5000 | 1312.5000 | 625.0000 | 17.19 MB | | EF | EFBenchmarks | Query | IEnumerable1 | 79.44 ms | 1.6880 ms | 1.5789 ms | 1 | 6250.0000 | - | - | 26.05 MB |
| SqlSugar | SqlSugarBenchmarks | Query | IEnumerable1 | 81.09 ms | 0.8718 ms | 0.7728 ms | 2 | 2187.5000 | 875.0000 | 250.0000 | 12.64 MB | | Chloe | ChloeBenchmarks | Query | IEnumerable1 | 83.86 ms | 1.2714 ms | 1.1893 ms | 3 | 2250.0000 | 937.5000 | 312.5000 | 12.62 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

简介

SmartSql-Starter

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 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.17134
Intel Core i7-6700K CPU 4.00GHz (Skylake), 1 CPU, 8 logical and 4 physical cores
.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 | Return | Mean | Error | StdDev | Rank | Gen 0 | Gen 1 | Gen 2 | Allocated |
|--------------- |------------------------- |------------------------ |-------------- |----------:|----------:|----------:|-----:|----------:|----------:|----------:|----------:|
| Native | NativeBenchmarks | Query_GetValue_DbNull | IEnumerable1 | 78.39 ms | 0.8935 ms | 0.7921 ms | 1 | 3000.0000 | 1125.0000 | 500.0000 | 15.97 MB | | SmartSql | SmartSqlBenchmarks | Query | IEnumerable1 | 78.46 ms | 0.2402 ms | 0.1875 ms | 1 | 2312.5000 | 1000.0000 | 312.5000 | 12.92 MB |
| SmartSqlDapper | SmartSqlDapperBenchmarks | Query | IEnumerable1 | 78.65 ms | 1.2094 ms | 1.1312 ms | 1 | 3687.5000 | 1437.5000 | 687.5000 | 19.03 MB | | Native | NativeBenchmarks | Query_IsDBNull_GetValue | IEnumerable1 | 78.84 ms | 0.8984 ms | 0.7502 ms | 1 | 2312.5000 | 1000.0000 | 312.5000 | 12.92 MB |
| Dapper | DapperBenchmarks | Query | IEnumerable1 | 79.00 ms | 1.0949 ms | 0.9706 ms | 1 | 3312.5000 | 1312.5000 | 625.0000 | 17.19 MB | | EF | EFBenchmarks | Query | IEnumerable1 | 79.44 ms | 1.6880 ms | 1.5789 ms | 1 | 6250.0000 | - | - | 26.05 MB |
| SqlSugar | SqlSugarBenchmarks | Query | IEnumerable1 | 81.09 ms | 0.8718 ms | 0.7728 ms | 2 | 2187.5000 | 875.0000 | 250.0000 | 12.64 MB | | Chloe | ChloeBenchmarks | Query | IEnumerable1 | 83.86 ms | 1.2714 ms | 1.1893 ms | 3 | 2250.0000 | 937.5000 | 312.5000 | 12.62 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

Release Notes

1. SmartSql.DyRepository add logger

NuGet packages (2)

Showing the top 2 NuGet packages that depend on SmartSql.DyRepository:

Package Downloads
SmartSql.DIExtension
SmartSql = MyBatis + Cache(Memory | Redis) + ZooKeeper + R/W Splitting +Dynamic Repository ....
SmartSql.Test
SmartSql = MyBatis + Cache(Memory | Redis) + ZooKeeper + R/W Splitting +Dynamic Repository ....

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
4.1.57 253 11/17/2020
4.1.56 683 7/14/2020
4.1.55 577 6/18/2020
4.1.54 337 6/12/2020
4.1.53 658 4/8/2020
4.1.52 411 3/27/2020
4.1.51 489 3/21/2020
4.1.50 370 3/9/2020
4.1.48 279 3/5/2020
4.1.46 450 12/18/2019
4.1.45 265 12/18/2019
4.1.44 403 12/5/2019
4.1.43 353 11/20/2019
4.1.42 422 11/18/2019
4.1.40 244 11/12/2019
4.1.39 289 11/6/2019
4.1.38 321 10/29/2019
4.1.37 259 10/29/2019
4.1.36 269 10/29/2019
4.1.35 287 10/29/2019
4.1.34 278 10/28/2019
4.1.33 275 10/28/2019
4.1.32 1,999 9/30/2019
4.1.31 272 9/29/2019
4.1.30 269 9/27/2019
4.1.29 284 9/26/2019
4.1.28 392 9/2/2019
4.1.27 316 8/30/2019
4.1.26 290 8/30/2019
4.1.25 303 8/30/2019
4.1.24 381 8/28/2019
4.1.23 1,568 8/20/2019
4.1.22 305 8/19/2019
4.1.21 317 8/13/2019
4.1.20 304 8/13/2019
4.1.19 331 8/13/2019
4.1.18 452 8/5/2019
4.1.17 438 8/1/2019
4.1.16 370 8/1/2019
4.1.15 341 7/30/2019
4.1.14 296 7/30/2019
4.1.12 356 7/30/2019
4.1.11 333 7/30/2019
4.1.9 355 7/29/2019
4.1.8 327 7/29/2019
4.1.7 293 7/29/2019
4.1.6 347 7/29/2019
4.1.5 305 7/27/2019
4.1.3 319 7/26/2019
4.1.2 344 7/25/2019
4.1.1 302 7/25/2019
4.1.0 322 7/24/2019
4.0.88 314 7/24/2019
4.0.86 336 7/22/2019
4.0.85 325 7/22/2019
4.0.84 296 7/22/2019
4.0.81 364 7/19/2019
4.0.80 344 7/19/2019
4.0.78 313 7/19/2019
4.0.76 366 7/17/2019
4.0.75 390 7/10/2019
4.0.73 367 7/10/2019
4.0.72 389 7/5/2019
4.0.71 441 6/25/2019
4.0.70 350 6/25/2019
4.0.69 353 6/25/2019
4.0.68 370 6/20/2019
4.0.66 374 6/18/2019
4.0.65 431 6/17/2019
4.0.63 792 6/12/2019
4.0.62 334 6/12/2019
4.0.60 404 6/11/2019
4.0.59 359 6/11/2019
4.0.58 462 6/3/2019
4.0.56 384 5/31/2019
4.0.55 335 5/30/2019
4.0.53 342 5/30/2019
4.0.52 349 5/30/2019
4.0.51 370 5/30/2019
4.0.50 347 5/29/2019
4.0.49 355 5/29/2019
4.0.48 364 5/24/2019
4.0.46 482 5/15/2019
4.0.45 390 5/10/2019
4.0.44 341 5/7/2019
4.0.43 272 5/7/2019
4.0.42 478 4/28/2019
4.0.41 278 4/28/2019
4.0.40 314 4/26/2019
4.0.38 326 4/26/2019
4.0.36 312 4/25/2019
4.0.35 320 4/25/2019
4.0.34 365 4/23/2019
4.0.33 333 4/19/2019
4.0.32 349 4/19/2019
4.0.30 307 4/19/2019
4.0.29 319 4/18/2019
4.0.28 310 4/18/2019
4.0.26 319 4/18/2019
4.0.25 294 4/17/2019
4.0.21 314 4/17/2019
4.0.20 319 4/16/2019
4.0.19 317 4/15/2019
4.0.18 305 4/15/2019
4.0.16 338 4/11/2019
4.0.15 297 4/11/2019
4.0.14 321 4/9/2019
4.0.13 273 4/9/2019
4.0.12 330 4/4/2019
4.0.11 273 4/4/2019
4.0.10 280 4/3/2019
4.0.8 246 4/3/2019
4.0.7 249 4/3/2019
4.0.6 237 4/3/2019
4.0.5 251 4/2/2019
4.0.4 250 4/2/2019
4.0.3 303 4/2/2019
4.0.2 260 4/1/2019
4.0.0 255 4/1/2019
4.0.0-rc999 208 3/31/2019
4.0.0-rc998 199 3/29/2019
4.0.0-rc997 195 3/29/2019
4.0.0-rc996 172 3/29/2019
4.0.0-rc995 194 3/28/2019
4.0.0-rc994 216 3/28/2019
4.0.0-rc993 223 3/28/2019
4.0.0-rc991 204 3/27/2019
4.0.0-rc990 203 3/27/2019
4.0.0-rc99 209 3/27/2019
4.0.0-rc98 209 3/26/2019
4.0.0-rc97 200 3/26/2019
4.0.0-rc96 206 3/26/2019
4.0.0-rc95 212 3/25/2019
4.0.0-rc93 197 3/25/2019
4.0.0-rc92 201 3/25/2019
4.0.0-rc91 208 3/22/2019
4.0.0-rc9 198 3/22/2019
4.0.0-rc8 201 3/21/2019
4.0.0-rc6 212 3/21/2019
4.0.0-rc5 203 3/20/2019
4.0.0-rc3 171 3/19/2019
4.0.0-rc10 198 3/22/2019
4.0.0-rc1 234 3/17/2019
4.0.0-beta5 218 3/16/2019
4.0.0-beta4 194 3/11/2019
4.0.0-beta3 205 3/9/2019
4.0.0-beta2 207 3/8/2019
4.0.0-beta1 217 3/7/2019
3.8.12 716 12/17/2018
3.8.8 271 12/11/2018
3.7.16 2,425 10/26/2018
3.7.15 354 10/24/2018
3.7.13 351 10/22/2018
3.7.10 398 10/11/2018
3.7.9 305 10/11/2018
3.6.1 879 8/10/2018
3.6.0 370 8/8/2018
3.6.0-rc2 299 8/7/2018
3.6.0-rc1 316 8/5/2018
3.6.0-pre8 348 8/5/2018
3.6.0-pre6 349 8/4/2018
3.5.9 378 8/1/2018
3.5.8 361 7/31/2018
3.5.6 326 7/31/2018
3.5.5 363 7/26/2018
3.5.4 368 7/26/2018
3.5.3 381 7/25/2018
3.5.0 374 7/24/2018
3.5.0-pre2 342 7/23/2018
3.4.9 364 7/21/2018
3.4.8 404 7/19/2018
3.4.6 390 7/19/2018
3.3.12 470 7/17/2018
3.3.10 378 7/16/2018
3.3.8 408 6/29/2018
3.3.6 410 6/26/2018
3.3.4 430 6/26/2018
3.3.2 511 6/21/2018
3.3.0 405 6/11/2018
3.2.0 422 6/11/2018
3.1.0 414 6/9/2018
3.0.0 400 6/2/2018
3.0.0-rc92 377 5/31/2018
3.0.0-rc91 356 5/30/2018
3.0.0-rc6 387 5/28/2018
3.0.0-rc11 440 5/30/2018
3.0.0-pre9 421 5/15/2018
3.0.0-pre2 417 5/6/2018
3.0.0-pre1 405 5/6/2018
1.0.1 420 4/24/2018
1.0.0 556 4/21/2018
1.0.0-pre 411 4/19/2018
Show less