Bug 20564 - SqlBulkCopy ordinal mappings do not work
Summary: SqlBulkCopy ordinal mappings do not work
Alias: None
Product: Class Libraries
Classification: Mono
Component: System.Data (show other bugs)
Version: master
Hardware: All All
: --- normal
Target Milestone: Untriaged
Assignee: Bugzilla
Depends on:
Reported: 2014-06-12 17:45 UTC by Andrew Knowles
Modified: 2018-02-22 22:36 UTC (History)
1 user (show)

See Also:
Is this bug a regression?: ---
Last known good build:


Description Andrew Knowles 2014-06-12 17:45:06 UTC
There are some issues with ordinal mappings.

Looks like source and destination are backwards in BulkCopyToServer.

Not to mention that neither is really correct there, since:
1) The source DataTable is passed in (this is the basis for the source ordinal)
2) The target table is specified (this is the basis for the target ordinal)
3) The target DataTable is calculated from the mappings (only the mapped columns are included).  The basis for this table is neither of the above two, and needs to be reconciled lest you get your mappings all crossed up.

And GenerateColumnMetaData is calculating the target DataTable incorrectly.  It should be in the target table's order, but only including the mapped columns (i.e., sorted by destination ordinal).
Comment 1 Marek Safar 2018-02-22 22:36:03 UTC
Mono 5.10 has significantly improved System.Data implementation which should resolve this issue. If you can still reproduce it please reopen the issue.

Note You need to log in before you can comment on or make changes to this bug.