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

Måns Tånneryd

Rate me:

4.96/5 (18 votes)

25 Jan 2012CPOL

92.6K

How to use bulk insert with your LINQ-to-SQL datacontext

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

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

23 Feb 2012RupertC

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...