Series: Batch Insert and Batch Update using Linq To SQL

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

Batch Insert using Linq To SQL (2)