Dapper Plus - Bulk Insert

INSERT entities using Bulk Operation.

Example - Insert Single

INSERT a single entity with Bulk Operation.

using (var connection = My.ConnectionFactory())
{
connection.Open();

connection.BulkInsert(invoice);
}

Example - Insert Many

INSERT many entities with Bulk Operation.

using (var connection = My.ConnectionFactory())
{
connection.Open();

connection.BulkInsert(invoices);
}

Example - Insert with relation (One to One)

INSERT entities with a one to one relation with Bulk Operation.

using (var connection = My.ConnectionFactory())
{
connection.Open();

connection.BulkInsert(invoices)
.ThenForEach(x => x.Detail.InvoiceID = x.InvoiceID)
.ThenBulkInsert(x => x.Detail);
}

Example - Insert with relation (One to Many)

INSERT entities with a one to many relation with Bulk Operation.

using (var connection = My.ConnectionFactory())
{
connection.Open();

connection.BulkInsert(invoices)
.ThenForEach(x => x.Items.ForEach(y => y.InvoiceID = x.InvoiceID))
.ThenBulkInsert(x => x.Items);
}