SQL Eval Function Introduction

Introduction

Entity Framework Extensions allows you to improve dramatically your save operations performance.

It's easy to use, and easy to customize.

Bulk SaveChanges

The BulkSaveChanges works like SaveChanges but way faster.

BulkSaveChanges uses Bulk Operations to save all entities in the Change Tracker efficiently instead of performing a database round-trip for every entity like SaveChanges does.

BulkSaveChanges support everything:

• Complex Types
• Inheritance (TPC, TPH, TPT)
• Relationship (One to One, One to Many, Many to Many)

Example

var ctx = new EntitiesContext();

ctx.Customers.AddRange(listToAdd); // add
ctx.Customers.RemoveRange(listToRemove); // remove
listToModify.ForEach(x => x.DateModified = DateTime.Now); // modify

// Easy to use
ctx.BulkSaveChanges();

// Easy to customize
context.BulkSaveChanges(bulk => bulk.BatchSize = 100);

Performance Comparisons

Bulk Operations

Bulk Operations method provide you some flexibility by allowing some customization and performance enhancement.

All common methods are supported:

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

Example

var ctx = new EntitiesContext();

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

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

Performance Comparisons

FromQuery Operations

FromQuery method allows you to execute UPDATE or DELETE statements without loading entities in the context.

Example

// 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
    .Where(x => x.IsActive && x.LastLogin < DateTime.Now.AddYears(-2))
    .UpdateFromQuery(x => new Customer {IsActive = false});

Performance Comparisons