Fourth_Experiment

SyncFileToDbBatchAdoNet

Drop table an insert the whole CSV with ADO.NET in batches. Build a large INSERT INTO query with paramaters.
The number of records inserted can be configured.

I did this experiment because the origional application did a truncate and bulk import, but did it as single record inserts.
The hope is that this method would perform better because it made fewer DB calls.