SqlBulkCopy Alternative for Temporary Table on SQL Azure
azure-sql-database bulkinsert c# sql sqlbulkcopy
Question
Just want to ask if theres an alternative way like "SqlBulkCopy" on inserting data to Temporary Table on SQL Azure via Datatable or Dataset.
SqlBulkCopy seems not supported on SQL Azure.
Popular Answer
SqlBulkCopy to temp table is now supported in SQL DB V12. You don't need these hacks now. If you are still on V11, TVP is the way to go.
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why