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)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: