Using System;
Using System.Data.Common;
Using System.Linq;
Using Dapper;
Using MySql.Data.MySqlClient;
Public classDapperbase<t>whereT:class,New() { /// <summary> ///Read Connection/// </summary> /// <returns></returns> PublicDbConnection getwriteconnection () {mysqlconnection connection=Newmysqlconnection (Webconfigutils.getwritedbconfig ()); //npgsqlconnection connection = new Npgsqlconnection (_sqlconnection);connection. Open (); returnconnection; } /// <summary> ///Read Connection/// </summary> /// <returns></returns> PublicDbConnection getreadconnection () {Try{mysqlconnection Connection=Newmysqlconnection (Webconfigutils.getreaddbconfig ()); Connection. Open (); returnconnection; } Catch(Exception) {returngetwriteconnection (); } } PublicT ExecuteSQL (stringSqlObjectobj) { using(varConnection =getreadconnection ()) { varModel =connection. Query<T>(SQL, obj). FirstOrDefault (); Connection. Close (); returnmodel; } } /// <summary> ///Transaction Execution SQL/// </summary> /// <param name= "SQL" ></param> /// <param name= "obj" ></param> /// <returns></returns> Public intExecutetransactionsql (stringSqlObjectobj) { using(varConnection =getwriteconnection ()) { vartrans =connection. BeginTransaction (); varrows =connection. Execute (SQL, Obj,trans); if(Rows >0) {trans.commit (); } Else{trans. Rollback (); } connection. Close (); returnrows; } } }
Share a dapper Simple package