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);

posted @ 2020-08-19 19:57  ITMrRight  阅读(617)  评论(0编辑  收藏  举报