Simple use of dapper (beginner induction)
Reference:
Using System;
Using System.Collections.Generic;
Using System.Linq;
Using System.Text;
Using System.Threading.Tasks;
Using System.Data;
Using System.Data.SqlClient;
Using System.Configuration;
Using Model;
Using Dapper;
Establishing a database connection
public static SqlConnection Sqlconn ()
{
String connstring = configurationmanager.connectionstrings["ConnString"]. ConnectionString;
var conntion = new SqlConnection (connstring);
Conntion. Open ();
return conntion;
}
List
Public list<user> GetList ()
{
using (idbconnection con = userdal.sqlconn ())
{
String Sqlcommandtex = "SELECT * from Tb_user";
List<user> userlist = Sqlmapper.query<user> (Con, Sqlcommandtex). ToList ();
return userlist;
}
}
Delete
public int del (int id)
{
using (idbconnection con = userdal.sqlconn ())
{
String comm = "Delete from Tb_user where id = @id";
int res = con. Execute (comm, new {id = id});
return res;
}
}
Parameter list
Public User GetUser (int id)
{
using (idbconnection con = userdal.sqlconn ())
{
String sql = "SELECT * from Tb_user where [email protected]";
User q = con. query<user> (SQL, new {id = id}). Singleordefault ();
return q;
}
}
Modify
public int UPD (User QQ)
{
using (idbconnection con = userdal.sqlconn ())
{
String sql = "Update tb_user set [email protected],[email protected],[email protected] where [email protected]";
int q = con. Execute (SQL, QQ);
return q;
}
}
Simple use of dapper (beginner induction)