Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
Entity Framework Core

EF Core ExecuteUpdate and ExecuteDelete: Mass Operations Without Loading Data

- 22.08.26 | 22.08.26 - ErcanOPAK

⚡ Key Takeaways: Update or delete thousands of records in a single database command without loading them into memory. Performance gains of 100x!

You’ve been loading entire tables just to update a few fields? EF Core 7+ has a better way: ExecuteUpdate and ExecuteDelete.

❌ The Old Way – Inefficient

// ❌ Loads ALL products into memory first!
var products = await context.Products
    .Where(p => p.Price < 100)
    .ToListAsync();  // ❌ 10,000 products loaded!

foreach (var product in products)
{
    product.Price = product.Price * 1.1m;  // 10% increase
    product.UpdatedAt = DateTime.UtcNow;
}

await context.SaveChangesAsync();  // ❌ 10,000 separate UPDATE statements!
// Memory: 50MB | Time: 15 seconds | DB Calls: 10,000

✅ The New Way – ExecuteUpdate

// ✅ Single database round-trip!
await context.Products
    .Where(p => p.Price < 100)
    .ExecuteUpdateAsync(setters => setters
        .SetProperty(p => p.Price, p => p.Price * 1.1m)
        .SetProperty(p => p.UpdatedAt, DateTime.UtcNow)
    );

// Memory: 0MB | Time: 150ms | DB Calls: 1
// 100x faster and 99% less memory!

💥 ExecuteDelete – Mass Deletion

// ❌ Load and delete one by one
var oldOrders = await context.Orders
    .Where(o => o.CreatedAt < DateTime.UtcNow.AddYears(-1))
    .ToListAsync();  // ❌ 50,000 orders loaded!

foreach (var order in oldOrders)
{
    context.Orders.Remove(order);
}
await context.SaveChangesAsync();  // ❌ 50,000 DELETEs!

// ✅ One DELETE statement!
await context.Orders
    .Where(o => o.CreatedAt < DateTime.UtcNow.AddYears(-1))
    .ExecuteDeleteAsync();

// Single DELETE FROM Orders WHERE CreatedAt < '2023-01-01'

🚀 Advanced Scenarios

// 1. Conditional updates with joins
await context.Products
    .Where(p => p.Category.Name == "Electronics")
    .ExecuteUpdateAsync(setters => setters
        .SetProperty(p => p.Discount, 0.15m)
        .SetProperty(p => p.UpdatedAt, DateTime.UtcNow)
    );

// 2. Use SQL functions
await context.Products
    .Where(p => p.Description != null)
    .ExecuteUpdateAsync(setters => setters
        .SetProperty(p => p.Name, p => p.Name.ToUpper())
        .SetProperty(p => p.Description, p => p.Description.Substring(0, 100))
    );

// 3. Based on related entities
await context.Orders
    .Where(o => o.Customer.Status == "Inactive")
    .ExecuteUpdateAsync(setters => setters
        .SetProperty(o => o.Status, "Cancelled")
        .SetProperty(o => o.CancelledAt, DateTime.UtcNow)
    );

⚠️ Important Limitations

// ❌ No navigation property updates
// Can't update related entities in one operation

// ❌ No tracking
// Entities are not tracked after update

// ❌ No validation
// EF Core doesn't validate before executing

// ❌ No interceptor support
// ChangeTracker is bypassed

📊 Performance Comparison

Operation Records Traditional ExecuteX Speedup
Update 10,000 12s 80ms 150x
Delete 50,000 45s 120ms 375x
Memory (Update) 10,000 45MB 0MB ∞

Related posts:

Entity Framework Core: 10x Performance Boost with AsNoTracking()

Entity Framework Core: 10x Performance Boost with AsNoTracking()

EF Core Bulk Operations: Insert 100,000 Records in Seconds

EF Core Bulk Operations: Insert 100,000 Records in Seconds

Views: 12

Post navigation

Rate Limiting in .NET 8: Shield Your API from DDoS Attacks Like a Pro
.dockerignore: The Secret to Lightning-Fast Docker Builds

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (661)
  • Add Constraint to SQL Table to ensure email contains @ (619)
  • Average of all values in a column that are not zero in SQL (577)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (553)
  • Find numbers with more than two decimal places in SQL (481)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store
  • WordPress: Fix a Navigation Block Losing Submenu Items After Sync
  • Visual Studio: Fix CodeLens Reference Counts Stuck at Stale Numbers
  • C#: Fix a UTF-8 String Literal Behaving Differently in a Switch
  • Photoshop: Fix a Liquify Mesh Snapping Back on a Smart Object
  • The AI Prompt That Turns a Crash Dump Into a Short Repro Script

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com