MySqlBulkCopy Column Mappings Set

[InvincibleDRT]

Unable to pass in custom order of column in DataTable to bulkcopy.

MySqlConnector/src/MySqlConnector/MySqlBulkCopy.cs

Line 46 in d9e59c7

public sealed class MySqlBulkCopy

Describe the solution you'd like
Change public List<MySqlBulkCopyColumnMapping> ColumnMappings { get; } to public List<MySqlBulkCopyColumnMapping> ColumnMappings { get; set;}

[bgrainger]

It sounds like you're asking for bulkCopy.ColumnMappings = myList;.

Instead of doing that, can you use bulkCopy.ColumnMappings.AddRange(myList);?

[bgrainger]

(The reason for the current design is that it allows object + collection initialization syntax.)

[InvincibleDRT]

I have tried that syntax as well. This is the error i see

AddRange worked. But may be you can default to column mapping in DataTable instead of defaulting to mapping from table in db!?

[InvincibleDRT]

With something like this
var mappings = (from DataColumn col in dt.Columns select new MySqlBulkCopyColumnMapping(col.Ordinal, col.ColumnName)).ToList();

[bgrainger]

But may be you can default to column mapping in DataTable instead of defaulting to mapping from table in db!?

This may be a duplicate of #1375?

[InvincibleDRT]

Closing since its duplicate