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
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why