Not sure how to do this:
I call a vendor's web services and bring back rows of data. The data is in array and i can loop thru it. For example, 1000+ rows.
I need to insert these rows into a database table. I dont want to loop thru and keep
inserting into the database one row at a time. How can I do this without keep calling the database to insert?
Should I dump the rows into a text file or Excel and import the excel?
foreach (var item in retVal.assetArray)
//dont want row by row insert. How to insert all at once in DB?