Dapper扩展之~~~Dapper.Contrib
平台之大势何人能挡? 带着你的Net飞奔吧!http://www.cnblogs.com/dunitian/p/4822808.html#skill
上一篇文章:Dapper逆天入门~强类型,动态类型,多映射,多返回值,增删改查+存储过程+事物案例演示
官方地址:https://github.com/StackExchange/dapper-dot-net/tree/master/Dapper.Contrib
实战案例:https://github.com/dunitian/LoTCode/tree/master/PawChina(更新ing)
注意点:Model里面的Table和Key是Dapper.Contrib.Extensions命名空间下的~~~~如果不是~~请看下篇文章(点我)
用法很简单,贴一下帮助类:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 | /// <summary> /// 扩展方法 /// </summary> public abstract partial class DapperDataAsync { #region 查询系 /// <summary> /// 获取Model-Key为int类型 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="id"></param> /// <param name="transaction"></param> /// <param name="commandTimeout"></param> /// <returns></returns> public static async Task<T> GetAsync<T>( int id, IDbTransaction transaction = null , int ? commandTimeout = null ) where T : class , new () { using ( var conn = ConnFactory.GetConnection()) { return await conn.GetAsync<T>(id, transaction, commandTimeout); } } /// <summary> /// 获取Model-Key为long类型 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="id"></param> /// <param name="transaction"></param> /// <param name="commandTimeout"></param> /// <returns></returns> public static async Task<T> GetAsync<T>( long id, IDbTransaction transaction = null , int ? commandTimeout = null ) where T : class , new () { using ( var conn = ConnFactory.GetConnection()) { return await conn.GetAsync<T>(id, transaction, commandTimeout); } } /// <summary> /// 获取Model-Key为Guid类型 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="id"></param> /// <param name="transaction"></param> /// <param name="commandTimeout"></param> /// <returns></returns> public static async Task<T> GetAsync<T>(System.Guid id, IDbTransaction transaction = null , int ? commandTimeout = null ) where T : class , new () { using ( var conn = ConnFactory.GetConnection()) { return await conn.GetAsync<T>(id, transaction, commandTimeout); } } /// <summary> /// 获取Model-Key为string类型 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="id"></param> /// <param name="transaction"></param> /// <param name="commandTimeout"></param> /// <returns></returns> public static async Task<T> GetAsync<T>( string id, IDbTransaction transaction = null , int ? commandTimeout = null ) where T : class , new () { using ( var conn = ConnFactory.GetConnection()) { return await conn.GetAsync<T>(id, transaction, commandTimeout); } } /// <summary> /// 获取Model集合(没有Where条件) /// </summary> /// <typeparam name="T"></typeparam> /// <returns></returns> public static async Task<IEnumerable<T>> GetAllAsync<T>() where T : class , new () { using ( var conn = ConnFactory.GetConnection()) { return await conn.GetAllAsync<T>(); } } #endregion #region 增删改 /// <summary> /// 插入一个Model /// </summary> /// <typeparam name="T"></typeparam> /// <param name="model"></param> /// <param name="transaction"></param> /// <param name="commandTimeout"></param> /// <param name="sqlAdapter"></param> /// <returns></returns> public static async Task< int > InsertAsync<T>(T model, IDbTransaction transaction = null , int ? commandTimeout = null ) where T : class , new () { using ( var conn = ConnFactory.GetConnection()) { return await conn.InsertAsync<T>(model, transaction, commandTimeout); } } /// <summary> /// 更新一个Model /// </summary> /// <typeparam name="T"></typeparam> /// <param name="connection"></param> /// <param name="entityToUpdate"></param> /// <param name="transaction"></param> /// <param name="commandTimeout"></param> /// <returns></returns> public static async Task<T> UpdateAsync<T>(T model, IDbTransaction transaction = null , int ? commandTimeout = null ) where T : class , new () { using ( var conn = ConnFactory.GetConnection()) { bool b = await conn.UpdateAsync<T>(model, transaction, commandTimeout); if (b) { return model; } else { return null ; } } } #endregion #region 分页查询 /// <summary> /// 分页查询(为什么不用out,请参考:http://www.cnblogs.com/dunitian/p/5556909.html) /// </summary> /// <param name="sql">查询语句</param> /// <param name="p">动态参数</param> /// <param name="sqlTotal">total语句</param> /// <param name="p2">Total动态参数</param> /// <returns></returns> public static async Task< string > PageLoadAsync<T>( string sql, object p = null , string sqlTotal = "" , object p2 = null ) { var rows = await QueryAsync<T>(sql.ToString(), p); var total = rows.Count(); if (!sqlTotal.IsNullOrWhiteSpace()) { total = await ExecuteScalarAsync< int >(sqlTotal, p2); } return new { rows = rows, total = total }.ObjectToJson(); } #endregion } |
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· 单线程的Redis速度为什么快?
· SQL Server 2025 AI相关能力初探
· 展开说说关于C#中ORM框架的用法!
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?