Using SQL bulk copy with your LINQ-to-SQL datacontext

If the order of your columns is different in the LINQ to SQL class from that in the database, then you also need to add a column mapping to the bulk copier. Otherwise you get mysterious errors in some of the loaded columns!

In my simple fix, I assume that the names match even if the order may have been messed about with. In this case you can add the following:

// Assume that the property name matches that in the database.
...

table.Columns.Add(new DataColumn(property.Name, propertyType));

bulkCopy.ColumnMappings.Add(
  new SqlBulkCopyColumnMapping(property.Name, property.Name));
...

For extra credit, the mapping could be pulled out of the LINQ attributes.