LinqToSql Plus Overview

Definition

LinqToSql Plus is a library that dramatically improves LinqToSql performances by using bulk and batch operations.

People using this library often report performance enhancement by 50x times and more!

The library is installed through NuGet. Extension methods are added automatically to your DbContext.

It easy to use and easy to customize.

// Easy to use
context.BulkInsert(list);
context.BulkUpdate(list);
context.BulkDelete(list);
context.BulkMerge(list);

// Easy to customize
context.BulkMerge(customers, options => 
	options.ColumnPrimaryKeyExpression = customer => customer.Code);

Installing

Download the NuGet Package

Requirements

LinqToSql

• System.Data.Linq

Database Provider

• SQL Server 2008+
• SQL Azure

Bulk Operations Methods

Bulk operation methods give you additional flexibility by allowing to customize options such as primary key, columns and more.

Bulk Operations Available:

• BulkInsert
• BulkUpdate
• BulkDelete
• BulkMerge (UPSERT operation)
• BulkSynchronize

Bulk Operations Examples

// Easy to use
context.BulkInsert(list);
context.BulkUpdate(list);
context.BulkDelete(list);
context.BulkMerge(list);

// Easy to customize
context.BulkMerge(customers, options => 
	options.ColumnPrimaryKeyExpression = customer => customer.Code; });

Performance Comparisons

Batch Operations Methods

Batch Operations method allow to perform UPDATE or DELETE operation directly in the database using a LINQ Query without loading entities in the context.

Everything is executed on the database side to let you get the best performance available.

Batch Operations Available:

• DeleteFromQuery
• UpdateFromQuery

Batch Operations Examples

// DELETE all customers that are inactive for more than two years
context.Customers
    .Where(x => x.LastLogin < DateTime.Now.AddYears(-2))
    .DeleteFromQuery();
 
// UPDATE all customers that are inactive for more than two years
context.Customers (Coming Soon)
    .Where(x => x.IsActive && x.LastLogin < DateTime.Now.AddYears(-2))
    .UpdateFromQuery(x => new Customer {IsActive = false});

Performance Comparisons