Dapper Data manipulation layer usage

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>//Database connection string///</summary> public static readonly String connectionString = configurationmanager.connectionstrings["constring"].        ConnectionString;        <summary>///Enquiry List///</summary>//<param name= "SQL" > Sql</param> of Queries <param name= "param" > Replacement parameters </param>//<returns></returns> public static List <T> Query (String sql, object param) {using (SqlConnection con = new SqlConnection (Connectionstrin g) {return con. query<t> (SQL, param).            ToList ();  }}///<summary>//query First Data      </summary>//<param name= "SQL" ></param>//<param name= "param" ></par            am>//<returns></returns> public static T Queryfirst (String sql, object param) { using (SqlConnection con = new SqlConnection (connectionString)) {return con.            queryfirst<t> (SQL, param); }}///<summary>///Query the first data does not return a default value///</summary>//<param name= "sql        "></param>//<param name=" param "></param>//<returns></returns> public static T Queryfirstordefault (String sql, object param) {using (SqlConnection con = new Sqlconnec tion (connectionString)) {return con.            queryfirstordefault<t> (SQL, param); }}///<summary>//Query single data///</summary>//<param name= "SQL" ></param>//<param name= "param" ></param>//<returns></returns> Publi C Static T Querysingle (String sql, object param) {using (SqlConnection con = new SqlConnection (connecti onstring)) {return con.            querysingle<t> (SQL, param); }}///<summary>//Query single data does not return default values///</summary>//<param name= "SQL" ></param>//<param name= "param" ></param>//<returns></returns> P Ublic static T Querysingleordefault (String sql, object param) {using (SqlConnection con = new Sqlconnec tion (connectionString)) {return con.            querysingleordefault<t> (SQL, param); }}///<summary>/////</summary>//<param name= "SQL" ></p aram>//<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 Access data///</summary>//<param name= "SQL" ;</param>//<param name= "param" ></param>///<returns></returns> Publ IC Static IDataReader ExecuteReader (String sql, object param) {using (SqlConnection con = new Sqlconnec tion (connectionString)) {return con.            ExecuteReader (SQL, param); }}///<summary>//Scalar get data///</summary>//<param name= "SQL" ;</param>//<param name= "param" ></param>///<returns></returns> Publ IC Static Object ExecutescaLar (String sql, object param) {using (SqlConnection con = new SqlConnection (connectionString)) {return con.            ExecuteScalar (SQL, param); }}///<summary>//Scalar get data///</summary>//<param name= "SQL" ;</param>//<param name= "param" ></param>///<returns></returns> Publ IC Static T Executescalarfort (String sql, object param) {using (SqlConnection con = new SqlConnection (c onnectionstring)) {return con.            executescalar<t> (SQL, param); }}///<summary>///For stored procedures with parameters///</summary>//<param name= "SQL" >&  lt;/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 File Download

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

Dapper Data manipulation layer usage