dapper批量操作 List<Test>list对象

using (var order = new OrderContext(DbMode.Slave1)) {
List<Test> t = new List<Test>();
t.Add(new Test() {
id = 1,
name = "fffff"
});
t.Add(new Test() {
id = 2,
name = "fffff"
});
t.Add(new Test() {
id = 3,
name = "xxxxxx"
});
string sql = "insert into test(id,name) VALUES(@id,@name)";
//var res = order.Dapper.Execute(sql,t);


var b = order.Dapper.Query("select * from test").ToList();

var c = order.Dapper.Execute("UPDATE test set name=@name where id=@id",t);


var a = order.Dapper.Execute("DELETE FROM test where name=@name",b);

原文地址:https://www.cnblogs.com/yjm8023/p/13531540.html