SmartSql.DyRepository
3.5.4
SmartSql 动态代理仓储
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
Install-Package SmartSql.DyRepository -Version 3.5.4
dotnet add package SmartSql.DyRepository --version 3.5.4
<PackageReference Include="SmartSql.DyRepository" Version="3.5.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SmartSql.DyRepository --version 3.5.4
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
简介
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
Release Notes
1. fix Generic nested return value bug
Dependencies
-
.NETFramework 4.6
- SmartSql (>= 3.5.3)
- System.ValueTuple (>= 4.5.0)
-
.NETStandard 2.0
- SmartSql (>= 3.5.3)
Used By
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 |