/// <summary>
/// 批量插入,不建议使用List插入、性能会受一定影响
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="context">当前DbContext</param>
/// <param name="tableName">要插入的表名称</param>
/// <param name="list">List列明必须与数据表列一致,严格大小写区分</param>
public static int BulkInsert <T>(this MySqlDbContext context, string tableName, IList <T> list)
{
var provider = new BulkInsertmmMySqlProvider(context);
var result = provider.BulkInsert(tableName, list);
return(result);
}
/// <summary>
/// 批量插入
/// </summary>
/// <param name="context">当前DbContext</param>
/// <param name="tableName">要插入的表名称</param>
/// <param name="dataTable">DataTable</param>
public static int BulkInsert(this MySqlDbContext context, string tableName, DataTable dataTable)
{
var provider = new BulkInsertmmMySqlProvider(context);
var result = provider.BulkInsert(tableName, dataTable);
return(result);
}