星空网 > 软件开发 > ASP.net

csharp:Dapper Sample

You can find Dapper on Google Code here: http://code.google.com/p/dapper-dot-net/ and the GitHub distro here: https://github.com/SamSaffron/dapper-dot-net.

    ///<summary>    /// 追加记录    ///</summary>    ///<param name="BookPlaceListInfo"></param>    ///<returns></returns>    public int InsertBookPlaceList(BookPlaceListInfo bookPlaceList)    {      int ret = 0;      try      {        List<BookPlaceListInfo> list=new List<BookPlaceListInfo>();        list.Add(bookPlaceList);        StringBuilder str = new StringBuilder();        str.Append("INSERT INTO BookPlaceList ");        str.Append("([BookPlaceName] ,[BookPlaceCode] ,[BookPlaceParent]) VALUES ");        str.Append("(@BookPlaceName ,@BookPlaceCode,@BookPlaceParent)");        ret=SqlMapperUtil.InsertMultiple<BookPlaceListInfo>(str.ToString(),list, SqlHelper.ConnectionString);      }      catch (SqlException ex)      {        throw ex;      }      return ret;    }    /// <summary>    /// 追加多条记录    /// </summary>    /// <param name="bookPlaceList"></param>    /// <returns></returns>    public int InsertBookPlaceListMore(List<BookPlaceListInfo> bookPlaceList)    {      int ret = 0;      try      {          StringBuilder str = new StringBuilder();        str.Append("INSERT INTO BookPlaceList ");        str.Append("([BookPlaceName] ,[BookPlaceCode] ,BookPlaceParent]) VALUES ");        str.Append("(@BookPlaceName ,@BookPlaceCode,@BookPlaceParent)");        ret = SqlMapperUtil.InsertMultiple<BookPlaceListInfo>(str.ToString(), bookPlaceList, SqlHelper.ConnectionString);      }      catch (SqlException ex)      {        throw ex;      }      return ret;    }    ///<summary>    ///修改记录    ///</summary>    ///<param name="BookPlaceListInfo"></param>    ///<returns></returns>    public int UpdateBookPlaceList(BookPlaceListInfo bookPlaceList)    {      int ret = 0;      try      {        List<BookPlaceListInfo> list = new List<BookPlaceListInfo>();        list.Add(bookPlaceList);        StringBuilder str = new StringBuilder();        str.Append("UPDATE BookPlaceList SET ");        str.Append("[BookPlaceName]=@BookPlaceName ,");        str.Append("[BookPlaceCode]=@BookPlaceCode,");        str.Append("[BookPlaceParent]=@BookPlaceParent");        str.Append(" where ");        str.Append("[BookPlaceID]=@BookPlaceID");        ret = SqlMapperUtil.InsertMultiple<BookPlaceListInfo>(str.ToString(), list, SqlHelper.ConnectionString);      }      catch (SqlException ex)      {        throw ex;      }      return ret;    }    ///<summary>    /// 删除记录    ///</summary>    ///<param name="bookPlaceIDInfo"></param>    ///<returns></returns>    public bool DeleteBookPlaceList(int bookPlaceID)    {      bool ret = false;      try      {        int temp = 0;        StringBuilder str = new StringBuilder();        str.Append("DELETE	BookPlaceList WHERE BookPlaceID = @BookPlaceID");        temp = SqlMapperUtil.InsertUpdateOrDeleteSql(str.ToString(), new { BookPlaceID = bookPlaceID }, SqlHelper.ConnectionString);                if (temp != 0)        {          ret = true;        }      }      catch (SqlException ex)      {        throw ex;      }      return ret;    }    ///<summary>    /// 查询记录    ///</summary>    ///<param name="bookPlaceIDInfo"></param>    ///<returns></returns>    public BookPlaceListInfo SelectBookPlaceList(int bookPlaceID)    {      BookPlaceListInfo bookPlaceList = null;      try      {        StringBuilder str = new StringBuilder();        str.Append("SELECT * FROM BookPlaceList WHERE BookPlaceID = @BookPlaceID");        bookPlaceList = SqlMapperUtil.SqlWithParamsSingle<BookPlaceListInfo>(str.ToString(), new { BookPlaceID = bookPlaceID }, SqlHelper.ConnectionString);      }      catch (SqlException ex)      {        throw ex;      }      return bookPlaceList;    }    ///<summary>    /// 查询所有记录    ///</summary>    ///<returns></returns>    public List<BookPlaceListInfo> SelectBookPlaceListAll()    {      List<BookPlaceListInfo> list = new List<BookPlaceListInfo>();           try      {        string str = "SELECT * FROM BookPlaceList";        list = SqlMapperUtil.SqlWithParams<BookPlaceListInfo>(str, null, SqlHelper.ConnectionString);      }      catch (SqlException ex)      {        throw ex;      }      return list;    }

  与SqlHelper比批量数据插入快近一半




原标题:csharp:Dapper Sample

关键词:

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

VAT审核流程及注意事项:https://www.kjdsnews.com/a/1335868.html
VAT审核方法如何轻松通过审核:https://www.kjdsnews.com/a/1335869.html
一则特别通知:卖家全网寻找恶搞者,答谢酬金高达30万!!:https://www.kjdsnews.com/a/1335870.html
揭秘出海品牌的秘密武器:语调和声音的力量!:https://www.kjdsnews.com/a/1335871.html
如何针对不同的年龄群组进行网页设计?:https://www.kjdsnews.com/a/1335872.html
抓狂!谷歌账号又又登录异常?给你支招解决:https://www.kjdsnews.com/a/1335873.html
TikTok 将推出先买后付服务 :https://www.goluckyvip.com/news/188219.html
深圳有没有比较好玩的景点 深圳有没有比较好玩的景点推荐一下:https://www.vstour.cn/a/366175.html
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流