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

Category: Entity Framework Core

Entity Framework Core

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

- 23.08.26 | 23.08.26 - ErcanOPAK comment on EF Core Bulk Operations: Insert 100,000 Records in Seconds

⚡ Key Takeaways: Insert, update, and delete thousands of records efficiently with EF Core Bulk extensions. 100x faster than standard SaveChanges. Entity Framework Core is great for single operations. For bulk operations, it’s painfully slow. Bulk extensions fix this. ❌ The Problem // ❌ 100,000 records – Each tracked individually var products = GenerateProducts(100000); foreach […]

Read More
Entity Framework Core

EF Core ExecuteUpdate and ExecuteDelete: Mass Operations Without Loading Data

- 22.08.26 | 22.08.26 - ErcanOPAK comment on EF Core ExecuteUpdate and ExecuteDelete: Mass Operations Without Loading Data

⚡ 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 […]

Read More
Entity Framework Core

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

- 19.08.26 | 19.08.26 - ErcanOPAK comment on Entity Framework Core: 10x Performance Boost with AsNoTracking()

By default, EF Core tracks every entity you query. For read-only scenarios, this is pure overhead. Use AsNoTracking() to eliminate it. The Problem – Tracking Overhead: // Default behavior: Tracking enabled var orders = context.Orders .Where(o => o.CustomerId == 123) .ToList(); // EF Core creates a snapshot of each entity // Tracks every property change […]

Read More
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