30% OFF - 9th Anniversary discount on new purchases until December 15 with code: ZZZANNIVERSARY9
Dapper Plus Also Bulk Insert
Description
The Dapper Plus AlsoBulkInsert method allows to INSERTs entities in a database table or a view using a lambda expression.
The lambda expression uses the entity or the IEnumerable
Also Bulk Insert with "One to One" Relation
The Dapper Plus AlsoBulkInsert method allows inserting a related item with a "One to One" relation.
//Insert an order and also the related invoice. connection.BulkInsert(order) .AlsoBulkInsert(order => order.Invoice); //Insert a list of orders and also the related invoice to every order. connection.BulkInsert(orders) .AlsoBulkInsert(order => order.Invoice);
Also Bulk Insert with "One to Many" Relation
The Dapper Plus AlsoBulkInsert method allows inserting related items with a "One to Many" relation.
//Insert an order and also all related items. connection.BulkInsert(order) .AlsoBulkInsert(order => order.Items); //Insert a list of orders and also all related items to every order. connection.BulkInsert(orders); .AlsoBulkInsert(order => order.Items);
Also Bulk Insert and Mixed Relation
The Dapper Plus AlsoBulkInsert method allows inserting related item(s) with any relation.
//Insert an order, also all related items and also the related invoice. connection.BulkInsert(order) .AlsoBulkInsert(order => order.Items, order => order.Invoice); //Insert a list of orders, also all related items to every order and also the related invoice to every order. connection.BulkInsert(orders) .AlsoBulkInsert(order => order.Items, order => order.Invoice);
Also Bulk Insert Chain Action
The Dapper Plus AlsoBulkInsert method allows chaining multiple bulk action methods.
//Insert an order and also all related items. Insert an invoice and also all related invoice items. connection.BulkInsert(order) .AlsoBulkInsert(order => order.Items) .BulkInsert(invoice) .AlsoBulkInsert(invoice => invoice.Items); //Insert a list of orders and also all related items to every order. Insert a list of invoices and also //all related items to every invoice. connection.BulkInsert(orders) .AlsoBulkInsert(order => order.Items) .BulkInsert(invoices) .AlsoBulkInsert(invoice => invoice.Items);
ZZZ Projects