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      }

 博客地址：http://dnt.dkill.net

本文转自毒逆天博客园博客，原文链接：http://www.cnblogs.com/dunitian/p/5710382.html，如需转载请自行联系原作者