c#Dapper 批量插入Mysql

<connectionStrings>
<add name="sqlconnectionString" connectionString="server=127.0.0.1;database=MyDataBase;User=sa;password=123456;Connect Timeout=1000000"/>
<add name="mysqlconnectionString" connectionString="Database=zyzs_terminal_info;Data Source=192.168.1.220;User Id=root;Password=root;CharSet=utf8;port=3306"/>
</connectionStrings>

string mysqlconnectionString = ConfigurationManager.ConnectionStrings["mysqlconnectionString"].ToString(); #region 向数据库中添加多条记录 +int Insert(Model.Contacts model) public int InsertBaseList(List<BaseTable> model)
{
#region SQL语句
const string sql = @"
INSERT INTO zyzs_terminal_base (license_number,shop_name,user_name,phone_number,shop_address)
VALUES (
@license_number
,@shop_name
,@user_name
,@phone_number
,@shop_address
);select @@IDENTITY"; using (var connection = new MySqlConnection(mysqlconnectionString))
{
connection.Open();
return connection.Execute(sql, model);
}
#endregion
} /// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name = "model" > 要添加的实体 </ param >
/// < returns > 插入数据的ID </ returns >
public int InsertBase(BaseTable model)
{
#region SQL语句
const string sql = @"
INSERT INTO zyzs_terminal_base (license_number,shop_name,user_name,phone_number,shop_address)
VALUES (
@license_number
,@shop_name
,@user_name
,@phone_number
,@shop_address
);select @@IDENTITY";
#endregion
using (var connection = new MySqlConnection(mysqlconnectionString))
{
connection.Open();
return connection.Execute(sql, model);
}
}
#endregion