SmartSql.Cache.Redis
3.0.0
Redis Cache For SmartSql
See the version list below for details.
Install-Package SmartSql.Cache.Redis -Version 3.0.0
dotnet add package SmartSql.Cache.Redis --version 3.0.0
<PackageReference Include="SmartSql.Cache.Redis" Version="3.0.0" />
paket add SmartSql.Cache.Redis --version 3.0.0
简介
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 缓存事务一致性
- 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 分布式配置文件加载器)
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 | IEnumerable
1 | 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 | IEnumerable
1 | 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 | IEnumerable
1 | 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 | IEnumerable
1 | 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
简介
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 缓存事务一致性
- 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 分布式配置文件加载器)
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 | IEnumerable
1 | 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 | IEnumerable
1 | 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 | IEnumerable
1 | 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 | IEnumerable
1 | 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
Dependencies
-
.NETFramework 4.6
- Newtonsoft.Json (>= 10.0.2)
- SmartSql (>= 3.0.0)
- StackExchange.Redis (>= 1.2.1)
-
.NETStandard 2.0
- Newtonsoft.Json (>= 10.0.2)
- SmartSql (>= 3.0.0)
- StackExchange.Redis (>= 1.2.1)
Used By
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version History
Version | Downloads | Last updated |
---|---|---|
4.1.57 | 99 | 11/17/2020 |
4.1.56 | 103 | 7/14/2020 |
4.1.55 | 159 | 6/18/2020 |
4.1.54 | 130 | 6/12/2020 |
4.1.53 | 188 | 4/8/2020 |
4.1.52 | 152 | 3/27/2020 |
4.1.51 | 198 | 3/21/2020 |
4.1.50 | 136 | 3/9/2020 |
4.1.48 | 142 | 3/5/2020 |
4.1.46 | 199 | 12/18/2019 |
4.1.45 | 146 | 12/18/2019 |
4.1.44 | 210 | 12/5/2019 |
4.1.43 | 164 | 11/20/2019 |
4.1.42 | 144 | 11/18/2019 |
4.1.41 | 157 | 11/12/2019 |
4.1.40 | 143 | 11/12/2019 |
4.1.39 | 142 | 11/6/2019 |
4.1.38 | 150 | 10/29/2019 |
4.1.37 | 152 | 10/29/2019 |
4.1.36 | 148 | 10/29/2019 |
4.1.35 | 133 | 10/29/2019 |
4.1.34 | 140 | 10/28/2019 |
4.1.33 | 146 | 10/28/2019 |
4.1.32 | 903 | 9/30/2019 |
4.1.31 | 154 | 9/29/2019 |
4.1.30 | 155 | 9/27/2019 |
4.1.29 | 152 | 9/26/2019 |
4.1.28 | 186 | 9/2/2019 |
4.1.27 | 156 | 8/30/2019 |
4.1.26 | 151 | 8/30/2019 |
4.1.25 | 153 | 8/30/2019 |
4.1.24 | 173 | 8/28/2019 |
4.1.23 | 650 | 8/20/2019 |
4.1.22 | 162 | 8/19/2019 |
4.1.21 | 171 | 8/13/2019 |
4.1.20 | 176 | 8/13/2019 |
4.1.19 | 171 | 8/13/2019 |
4.1.18 | 205 | 8/5/2019 |
4.1.17 | 198 | 8/1/2019 |
4.1.16 | 189 | 8/1/2019 |
4.1.15 | 189 | 7/30/2019 |
4.1.14 | 171 | 7/30/2019 |
4.1.12 | 187 | 7/30/2019 |
4.1.11 | 178 | 7/30/2019 |
4.1.10 | 176 | 7/30/2019 |
4.1.9 | 193 | 7/29/2019 |
4.1.8 | 184 | 7/29/2019 |
4.1.7 | 180 | 7/29/2019 |
4.1.6 | 191 | 7/29/2019 |
4.1.5 | 185 | 7/27/2019 |
4.1.3 | 178 | 7/26/2019 |
4.1.2 | 194 | 7/25/2019 |
4.1.1 | 177 | 7/25/2019 |
4.1.0 | 197 | 7/24/2019 |
4.0.88 | 178 | 7/24/2019 |
4.0.86 | 172 | 7/22/2019 |
4.0.85 | 172 | 7/22/2019 |
4.0.84 | 175 | 7/22/2019 |
4.0.81 | 192 | 7/19/2019 |
4.0.80 | 190 | 7/19/2019 |
4.0.78 | 182 | 7/19/2019 |
4.0.76 | 187 | 7/17/2019 |
4.0.75 | 205 | 7/10/2019 |
4.0.73 | 198 | 7/10/2019 |
4.0.72 | 193 | 7/5/2019 |
4.0.71 | 198 | 6/25/2019 |
4.0.70 | 203 | 6/25/2019 |
4.0.69 | 197 | 6/25/2019 |
4.0.68 | 185 | 6/20/2019 |
4.0.66 | 197 | 6/18/2019 |
4.0.65 | 188 | 6/17/2019 |
4.0.63 | 595 | 6/12/2019 |
4.0.62 | 190 | 6/12/2019 |
4.0.60 | 200 | 6/11/2019 |
4.0.59 | 195 | 6/11/2019 |
4.0.58 | 225 | 6/3/2019 |
4.0.56 | 210 | 5/31/2019 |
4.0.55 | 215 | 5/30/2019 |
4.0.53 | 229 | 5/30/2019 |
4.0.52 | 228 | 5/30/2019 |
4.0.51 | 210 | 5/30/2019 |
4.0.50 | 224 | 5/29/2019 |
4.0.49 | 200 | 5/29/2019 |
4.0.48 | 213 | 5/24/2019 |
4.0.46 | 218 | 5/15/2019 |
4.0.45 | 219 | 5/10/2019 |
4.0.44 | 223 | 5/7/2019 |
4.0.43 | 209 | 5/7/2019 |
4.0.42 | 225 | 4/28/2019 |
4.0.41 | 216 | 4/28/2019 |
4.0.40 | 220 | 4/26/2019 |
4.0.38 | 233 | 4/26/2019 |
4.0.36 | 253 | 4/25/2019 |
4.0.35 | 249 | 4/25/2019 |
4.0.34 | 285 | 4/23/2019 |
4.0.33 | 229 | 4/19/2019 |
4.0.32 | 222 | 4/19/2019 |
4.0.30 | 220 | 4/19/2019 |
4.0.29 | 233 | 4/18/2019 |
4.0.28 | 231 | 4/18/2019 |
4.0.26 | 221 | 4/18/2019 |
4.0.25 | 224 | 4/17/2019 |
4.0.21 | 241 | 4/17/2019 |
4.0.20 | 244 | 4/16/2019 |
4.0.19 | 228 | 4/15/2019 |
4.0.18 | 231 | 4/15/2019 |
4.0.16 | 254 | 4/11/2019 |
4.0.15 | 238 | 4/11/2019 |
4.0.14 | 227 | 4/9/2019 |
4.0.13 | 224 | 4/9/2019 |
4.0.12 | 231 | 4/4/2019 |
4.0.11 | 227 | 4/4/2019 |
4.0.0 | 227 | 4/1/2019 |
4.0.0-rc996 | 179 | 3/29/2019 |
4.0.0-rc993 | 187 | 3/28/2019 |
4.0.0-rc95 | 189 | 3/25/2019 |
4.0.0-rc1 | 188 | 3/17/2019 |
4.0.0-beta5 | 208 | 3/16/2019 |
4.0.0-beta1 | 211 | 3/7/2019 |
3.2.0 | 819 | 12/5/2018 |
3.1.0 | 345 | 7/31/2018 |
3.0.0 | 409 | 6/2/2018 |
3.0.0-pre8 | 379 | 5/15/2018 |
1.4.8 | 560 | 4/25/2017 |
1.4.3 | 492 | 4/20/2017 |
1.4.2 | 481 | 4/20/2017 |