Bulk Insert multiple records and get identity for all using ADO.NET
- by Hasan Khan
I want to batch insert multiple records in sql server database using ADO.NET command/sqldataadapter and get identity value generated for all the rows in a single database trip.
What are my options?