Bulk Insert multiple records and get identity for all using ADO.NET

Question

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?

Answer 1

If you're using either, SQL server 2005 and 2008 add support for the OUTPUT clause, which enables you to return a result-set from an UPDATE/INSERT/DELETE statement.