不要框架,不要类库,只要引入一个单元sqlmapper*.cs,下载地址:https://download.csdn.net/download/pxgame/10302588
//将man插入mysql
class man =new clsman();
string sql=" insert into...
using (system.data.IDbConnection conn = MySql.Data.MySqlClient.MySqlConnection("server=localhost;User Id=root;password=admin;Database=test"))
{
var n = conn.Execute(sql,man);//影响行数量
}
//获取man
var sql = "p_getuserinfo";
using (IDbConnection conn = GetSqlConnection())
{
var list = conn.Query<user_infoModel>(sql,
new
{
_userid =45
},
null,
true,
null,
CommandType.StoredProcedure).ToList();
//将man插入mysql
class man =new clsman();
string sql=" insert into...
using (system.data.IDbConnection conn = MySql.Data.MySqlClient.MySqlConnection("server=localhost;User Id=root;password=admin;Database=test"))
{
var n = conn.Execute(sql,man);//影响行数量
}
//获取man
var sql = "p_getuserinfo";
using (IDbConnection conn = GetSqlConnection())
{
var list = conn.Query<user_infoModel>(sql,
new
{
_userid =45
},
null,
true,
null,
CommandType.StoredProcedure).ToList();