public async Task InsertAsync()
{
var batchInsertNum = 1000000;
var batchTable = new DbTable("t_test");
batchTable.AddColumn(new DbColumn
{
AutoIncrement = true,
DataType = typeof(long),
Name = "id"
});
batchTable.AddColumn("name");
batchTable.AddColumn("no");
for (var i = 0; i < batchInsertNum; i++)
{
var row = batchTable.AddRow();
row["name"] = "SmartSql-" + Guid.NewGuid().ToString("N");
row["no"] = i;
}
using (BatchInsert batchInsert = new BatchInsert(_sqlMapper))
{
batchInsert.Table = batchTable;
await batchInsert.InsertAsync();
}
}
public async Task InsertAsync()
{
var batchInsertNum = 1000000;
var batchTable = new DbTable("t_test");
batchTable.AddColumn("Name");
batchTable.AddColumn("No");
for (var i = 0; i < batchInsertNum; i++)
{
var row = batchTable.AddRow();
row["Name"] = "SmartSql-" + Guid.NewGuid().ToString("N");
row["No"] = i;
}
using (BatchInsert batchInsert = new BatchInsert(_sqlMapper))
{
batchInsert.Table = batchTable;
batchInsert.AddColumnMapping(new ColumnMapping
{
Column = "Name",
Mapping = "name"
});
batchInsert.AddColumnMapping(new ColumnMapping
{
Column = "No",
Mapping = "no"
});
await batchInsert.InsertAsync();
}
}
public void Insert()
{
var batchInsertNum = 1000000;
var batchTable = new DbTable("t_test");
batchTable.AddColumn(new DbColumn
{
AutoIncrement = true,
DataType = typeof(long),
Name = "id"
});
batchTable.AddColumn("name", typeof(string));
batchTable.AddColumn("no", typeof(int));
for (var i = 0; i < batchInsertNum; i++)
{
var row = batchTable.AddRow();
row["name"] = "SmartSql-" + Guid.NewGuid().ToString("N");
row["no"] = i;
}
using (BatchInsert batchInsert = new BatchInsert(_sqlMapper))
{
batchInsert.Table = batchTable;
batchInsert.AddColumnMapping(new ColumnMapping
{
Column = "id",
Mapping = "Id"
});
batchInsert.AddColumnMapping(new ColumnMapping
{
Column = "name",
Mapping = "Name"
});
batchInsert.AddColumnMapping(new ColumnMapping
{
Column = "no",
Mapping = "No"
});
batchInsert.Insert();
}
}
/// <summary>
/// Inserts multiple records
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="dbContext"></param>
/// <param name="tableName"></param>
/// <param name="entities"></param>
/// <param name="schema"></param>
public static int BulkInsert <TEntity>(this DbContext dbContext, string tableName, IEnumerable <TEntity> entities, string schema = null)
{
return(BatchInsert.Execute(dbContext, tableName, entities, schema));
}
/// <summary>
/// Inserts multiple records
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="dbContext"></param>
/// <param name="entities"></param>
public static int BulkInsert <TEntity>(this DbContext dbContext, IEnumerable <TEntity> entities)
{
return(BatchInsert.Execute(dbContext, entities));
}
