✨ อัปเดตล่าสุด: tag/ef

Level UI • 20 hours • in Articles • 9 min read

An MCP server is not a new API. It is a thin layer over the one you already have

Somewhere in the last year, "do we need an MCP server?" joined the list of questions that arrive in a brief before anyone has said what the thing is for. It is usually framed as MCP vs API, as though the Model Context Protocol were a newer kind of AP...

7 Reactions 7 Comments

Spyros • Jun 29 • in Articles • 4 min read

🚀 EF Core Query Optimization for Beginners

When developers first start using Entity Framework Core, it's easy to write queries that work—but not all queries perform well. The good news? A few simple practices can make your queries much faster, use less memory, and generate better SQL. We'll...

2 Reactions 2 Comments

Spyros • Jun 5 • in Articles • 2 min read

5 EF Core Features Every Enterprise Developer Should Know

Entity Framework Core EF Core is often introduced as an ORM that simplifies data access, but its real value in enterprise applications comes from features that improve reliability, scalability, and maintainability. As applications grow and operate ...

7 Reactions 2 Comments

Spyros • Feb 16 • in Articles • 1 min read

When IDbContextFactory enters the chat, and what it actually fixes.

When IDbContextFactory enters the chat, and what it actually fixes Most EF Core examples use a scoped DbContext. In a normal Web API request, that’s fine, the request ends, the context is disposed. Then you build Blazor Server. A Blazor Server ci...

2 Reactions 3 Comments

Spyros • Oct 13, 2025 • in Articles • 5 min read

Reliable Messaging in .NET: Domain Events and the Outbox Pattern with EF Core Interceptors

Introduction Distributed systems are powerful — but they come with one big challenge: reliability. What happens if your application updates a record in the database and then tries to publish a message to a message broker… but crashes in between? ...

4 Reactions 4 Comments

Spyros • Aug 5, 2025 • in Articles • 2 min read

Supercharging EF Core Specifications with EF.CompileQuery

1. Introduction When you’re using EF Core in production, query compilation can quietly become a performance bottleneck — especially if the same query is executed thousands of times. Normally, EF Core parses your LINQ, generates SQL, and prepares ...

5 Reactions 4 Comments

Spyros • Jul 25, 2025 • in Articles • 3 min read

⚔️ The Mighty MERGE: Using SQL Merge Statements Safely with EF Core

When you’re working with bulk data operations, upserts, or syncing external sources, MERGE is one of the most powerful tools SQL Server offers. But what happens when you need to use it alongside Entity Framework Core? In this article, we’ll cover: ...

7 Reactions 3 Comments

Spyros • Mar 31, 2025 • in Articles • 3 min read

Optimistic vs. Pessimistic Concurrency in EF Core (with Table Hints)

Many experienced developers are familiar with database transactions but often overlook the key differences between optimistic and pessimistic concurrency control in Entity Framework Core EF Core. Understanding both approaches and how EF Core handle...

12 Reactions 4 Comments

Spyros • Mar 24, 2025 • in Articles • 3 min read

EF Core Bulk Updates and Deletes: Performance vs Change Tracking

Entity Framework Core 7 introduced two powerful methods for bulk operations: ExecuteUpdateAsync and ExecuteDeleteAsync. These methods are designed for high-performance scenarios where you need to update or delete multiple records efficiently with...

4 Reactions 2 Comments

Spyros • Mar 20, 2025 • in Articles • 3 min read

EF Core Interceptors: Supercharge Your Data Access with the Decorator Pattern

Learn how to hook into EF Core operations using interceptors, leverage the Decorator Pattern for clean cross-cutting concerns, and see real-world examples like SQL logging and auditing. Table of Contents A Brief History of EF Core Interceptors Wha...

4 Reactions 2 Comments

Spyros • Mar 6, 2025 • in Articles • 3 min read

EF Core: Lazy Loading, Eager Loading, and Loading Data on Demand

When working with Entity Framework Core EF Core, there are different strategies for loading related data from the database. So, how do you load a collection or other related objects? Here are the main options: 1️⃣ Eager Loading Include Loads rela...

5 Reactions 4 Comments

Spyros • Mar 2, 2025 • in Articles • 2 min read

EF Core Global Query Filters: A Complete Guide

Entity Framework Core EF Core Global Query Filters allow you to apply filters to queries at the model level so that they automatically apply to all queries involving a specific entity. This is particularly useful for scenarios like soft deletes, mu...

3 Reactions 2 Comments

Spyros • Feb 26, 2025 • in Articles • 2 min read

When to Use AsSplitQuery() in EF.core

When working with Entity Framework Core EF Core, queries that involve multiple Include statements can result in a single large query with multiple joins. This can cause performance issues due to data duplication and increased memory usage. What is A...

7 Reactions 2 Comments

Welcome to Coder Legion

Connect with 5,750 amazing developers

Don't have an account? Sign up

OR

Recent posts tagged ef