Hi guys,
Quick q - I'm working on an ASP.NET C# web app (but my question is framework-related, not specific to my app).
The SqlBulkCopy class - can it return values (thinking primary key/s here)?
In my instance, I'm inserting a bunch of rows in a contacts table, but then I need to grab all the new IDs of the contacts so I can go and insert them into another table. I don't want to have to use a stored procedure cause that takes aaaaages... *snore* lol.
Thanks in advance,
codegecko
Quick q - I'm working on an ASP.NET C# web app (but my question is framework-related, not specific to my app).
The SqlBulkCopy class - can it return values (thinking primary key/s here)?
In my instance, I'm inserting a bunch of rows in a contacts table, but then I need to grab all the new IDs of the contacts so I can go and insert them into another table. I don't want to have to use a stored procedure cause that takes aaaaages... *snore* lol.
Thanks in advance,
codegecko