Why does the returned DataTable has readonly columns in FileHelpers

Question

I am wondering why filehelpers return readonly columns.

I had a huge problem with them not updating values and could not figure out why. Now I have to have another loop to go through all the columns and change them to be not readonly.

Is there a way I can tell Filehelpers to not do this? So I don't have to waste time going through all of it again?

Answer 1

The FileHelpers class RecordOperations.CreateEmptyDataTable() method is responsible for this and it is not virtual.

I think the reason might be that it is similar to using a normal DataReader via DataTable.Load(IReader) which would also create readonly rows.

However, it is easy to fix by going through the columns instead of the rows:

foreach (DataColumn col in dt.Columns) 
    col.ReadOnly = false;