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.
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.