C# – Batch identity inserts

home
ado.net
view story

1 Kicks

C# – Batch identity inserts(daniel.wertheim.se)

submitted by sedanwer(216) 1 year, 6 months ago

I’m currently building support for identity inserts in SisoDb where I need to let the database generate the ids and then assign them to the entities. To get better performance I want to batch up the inserts and sending them in a large chunk to the Sql-server and I want to make use of parameters to be protected from sql-injection attacks. You can of course use SqlBulkCopy but it will not let you get the generated identities so that you can assign them to your entities.

add a comment |category: ADO.NET |Views: 6
Tweet