.Net集成Dapper

1.在NuGet里面搜索Dapper，找到需要下载的组件包

2.把Dapper安裝到需要使用的类库下面
3.自己封装一个Repository类，数据库连接，增、删、查、改进行封装
4.在配置文件里面配置好数据库连接字符串

5.调用示例

  string strSQL = $@"select * from FinanceAccountingPeriods where AccountingPeriod='{AccountingPerioddate}'";
  AcsdbContext acsdbContext = new AcsdbContext();
  var query= acsdbContext.Query<FinanceAccountingPeriods>(strSQL);

附录：AcsdbContext类的代码

using Dapper;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;

namespace AcsJobCommon.Repository
{
    /// <summary>
    /// 数据库操作类
    /// </summary>
    public class AcsdbContext
    {
        private string connectionString;
        public AcsdbContext()
        {
            connectionString = ConfigurationManager.AppSettings["ACSDB"].ToString();
        }
        public IDbConnection Connection
        {
            get
            {
                return new SqlConnection(connectionString);
            }
        }
        //查询的封装方法-查询同步
        public IEnumerable<T> Query<T>(string sql)
        {
            using (IDbConnection dbConnection = Connection)
            {
                dbConnection.Open();
                return dbConnection.Query<T>(sql);
            }
        }

        /// <summary>
        /// 新增封装方法-新增同步
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public int Insert(string sql)
        {
            using (IDbConnection dbConnection = Connection)
            {
                dbConnection.Open();
                return dbConnection.Execute(sql);
            }
        }

        /// <summary>
        /// 更新封装方法-更新同步
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public int Update(string sql)
        {
            using (IDbConnection dbConnection = Connection)
            {
                dbConnection.Open();
                return dbConnection.Execute(sql);
            }
        }

        /// <summary>
        /// 删除封装方法-删除同步
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public int Delete(string sql)
        {
            using (IDbConnection dbConnection = Connection)
            {
                dbConnection.Open();
                return dbConnection.Execute(sql);
            }
        }

        /// <summary>
        /// 查询存储过程-
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        //public IEnumerable<T> QueryCustomerproductProcedure<T>(string customercode_sap,string productid_sap,string po_unitcode)
        //{
        //    using (IDbConnection dbConnection = Connection)
        //    {
        //        var param = new DynamicParameters();
        //        param.Add("@Customercode_sap", customercode_sap);
        //        param.Add("@productid_sap", productid_sap);
        //        param.Add("@po_unit", po_unitcode);
                
        //        dbConnection.Open();
        //        return dbConnection.Query<T>("sp_bm_customerproduct_get_result", param, null, true, null, CommandType.StoredProcedure);
        //    }
        //}




    }
}