LinqToSql Plus Delete from Query

Description

DELETE all rows from the database using a LINQ Query without loading entities in the context.

A DELETE statement is built using the LINQ expression and directly executed in the database.

// DELETE all customers that are inactive
context.Customers.Where(x => !x.IsActive).DeleteFromQuery();

// DELETE customers by id
context.Customers.Where(x => x.ID == userId).DeleteFromQuery();

Purpose

Deleting entities using SubmitChanges normally requires to load them first in the ChangeTracker. These additional round-trips are often not necessary.

DeleteFromQuery gives you access to directly execute a DELETE statement in the database and provide a HUGE performance improvement.

Performance Comparisons