SQLsugar批量如何写
时间: 2024-05-15 22:19:08 浏览: 17
SQLSugar批量操作有三种方式:
1. 使用InsertRange方法:
```
List<User> userList=new List<User>();
userList.Add(new User(){Name="张三",Age=18});
userList.Add(new User(){Name="李四",Age=20});
using(var db=new SqlSugarClient())
{
db.InsertRange(userList);
}
```
2. 使用SqlBulkCopy方式:
```
List<User> userList=new List<User>();
userList.Add(new User(){Name="张三",Age=18});
userList.Add(new User(){Name="李四",Age=20});
using(var db=new SqlSugarClient())
{
db.SqlBulkCopy(userList);
}
```
3. 手写SQL语句:
```
List<User> userList=new List<User>();
userList.Add(new User(){Name="张三",Age=18});
userList.Add(new User(){Name="李四",Age=20});
string sql="insert into User(Name,Age) values ";
foreach(var user in userList)
{
sql+=string.Format("('{0}',{1}),",user.Name,user.Age);
}
sql=sql.TrimEnd(',');
using(var db=new SqlSugarClient())
{
db.Ado.ExecuteCommand(sql);
}
```