Dapper資料操作層使用

標籤：

using System;using System.Collections.Generic;using System.Configuration;using System.Linq;using System.Text;using System.Threading.Tasks;using Dapper;using System.Data.SqlClient;using System.Data;namespace YuPen.DAL{    public class DapperHelper<T> where T : class    {        /// <summary>        /// 資料庫連接字串        /// </summary>        public static readonly string connectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;        /// <summary>        /// 查詢列表        /// </summary>        /// <param name="sql">查詢的sql</param>        /// <param name="param">替換參數</param>        /// <returns></returns>        public static List<T> Query(string sql, object param)        {            using (SqlConnection con = new SqlConnection(connectionString))            {                return con.Query<T>(sql, param).ToList();            }        }        /// <summary>        /// 查詢第一個資料        /// </summary>        /// <param name="sql"></param>        /// <param name="param"></param>        /// <returns></returns>        public static T QueryFirst(string sql, object param)        {            using (SqlConnection con = new SqlConnection(connectionString))            {                return con.QueryFirst<T>(sql, param);            }        }        /// <summary>        /// 查詢第一個資料沒有返回預設值        /// </summary>        /// <param name="sql"></param>        /// <param name="param"></param>        /// <returns></returns>        public static T QueryFirstOrDefault(string sql, object param)        {            using (SqlConnection con = new SqlConnection(connectionString))            {                return con.QueryFirstOrDefault<T>(sql, param);            }        }        /// <summary>        /// 查詢單條資料        /// </summary>        /// <param name="sql"></param>        /// <param name="param"></param>        /// <returns></returns>        public static T QuerySingle(string sql, object param)        {            using (SqlConnection con = new SqlConnection(connectionString))            {                return con.QuerySingle<T>(sql, param);            }        }        /// <summary>        /// 查詢單條資料沒有返回預設值        /// </summary>        /// <param name="sql"></param>        /// <param name="param"></param>        /// <returns></returns>        public static T QuerySingleOrDefault(string sql, object param)        {            using (SqlConnection con = new SqlConnection(connectionString))            {                return con.QuerySingleOrDefault<T>(sql, param);            }        }        /// <summary>        /// 曾刪改        /// </summary>        /// <param name="sql"></param>        /// <param name="param"></param>        /// <returns></returns>        public static int Execute(string sql, object param)        {            using (SqlConnection con = new SqlConnection(connectionString))            {                return con.Execute(sql, param);            }        }        /// <summary>        /// Reader擷取資料        /// </summary>        /// <param name="sql"></param>        /// <param name="param"></param>        /// <returns></returns>        public static IDataReader ExecuteReader(string sql, object param)        {            using (SqlConnection con = new SqlConnection(connectionString))            {                return con.ExecuteReader(sql, param);            }        }        /// <summary>        /// Scalar擷取資料        /// </summary>        /// <param name="sql"></param>        /// <param name="param"></param>        /// <returns></returns>        public static object ExecuteScalar(string sql, object param)        {            using (SqlConnection con = new SqlConnection(connectionString))            {                return con.ExecuteScalar(sql, param);            }        }        /// <summary>        /// Scalar擷取資料        /// </summary>        /// <param name="sql"></param>        /// <param name="param"></param>        /// <returns></returns>        public static T ExecuteScalarForT(string sql, object param)        {            using (SqlConnection con = new SqlConnection(connectionString))            {                return con.ExecuteScalar<T>(sql, param);            }        }        /// <summary>        /// 帶參數的預存程序        /// </summary>        /// <param name="sql"></param>        /// <param name="param"></param>        /// <returns></returns>        public static List<T> ExecutePro(string proc, object param)        {            using (SqlConnection con = new SqlConnection(connectionString))            {                List<T> list = con.Query<T>(proc,                                            param,                                            null,                                            true,                                            null,                                            CommandType.StoredProcedure).ToList();                return list;            }        }    }}

Dapper檔案下載

http://files.cnblogs.com/files/huweizhong/Dapper.zip

Dapper資料操作層使用