Want a simple yet super fast method to insert a list of data in array OR a Range to Azure SQL.
1. The method should be able to dynamically assign columns name.
2. The insert method must do a batch insert instead of one by one.
3. The method should be able to insert 10, 000 records within 20 seconds or faster.
4. Please don't use the ExportRangeToSQL method from the internet, I already have this method and the performance is not satisfy.
5. Please consider there will be over 50k data need to be bulk insert and it have to be fast (<= 120 seconds)。
6. The number of columns is about 55 columns.
Please let me know the way you plan to do for me to review then I will decide whether should let you handle this project