I've been trying to use the CsvLoader and have come a bit unstuck.
Where the underlying field is a string, the loader appears the entyr in the CSV file to start with a "'" (single quotation mark). It then processes the remainder of the string up to the next comma.
If you add a terminating quote this is included in the value in the transient data base. So
ID, Name, Description
ID 1 causes an exception as a ' is needed to prefix a string.
ID 2 returns Iain' and Writer' as the values in the database
ID 2 puts what you expect in the fields.
This was a bit confusing. FIrstly, you can have CSV files without using quotes to escape fields. You have to use quotes if there is a comma in the field, otherwise you don't. If you do use quotes they should appear at the start and end
of the field contents.
Also, my experience is that the double quote " is the more common delimiter rather than single quote.
I'm using code pulled by Git sometime last week as I'm working with DbContext.
Is this a bug or have I got the wrong end of the stick? :)