Linq To SQL does not natively support bulk operations (batch operations).
A new batch operation should operate on the existing Linq To SQL infrastructure, namely
- the L2S DataContext
- the class declarations of the data model generated by the .dbml designer
This series sketches an implementation of batch operations using Linq To SQL:
Introduction
Bulk Operations using Linq To SQL
Batch Update
Batch Update using Linq To SQL
Generating T-SQL from Linq queries
Converting Linq Expressions to T-SQL
Batch Insert
Batch Insert using Linq To SQL
Batch Insert with Column Mapping