23 min read
EF Core Split Queries: The Hidden LIMIT Slowing PostgreSQL
EF Core split queries with SingleOrDefaultAsync hide a LIMIT subquery PostgreSQL can't optimize. One extension method took an endpoint from 5.45s to 155ms.
> .NET · C# · ASP.NET Core · Azure
I’m a backend developer and .NET technical writer for Code Maze. I write in-depth, code-first guides on C#, ASP.NET Core Minimal APIs, Entity Framework Core and Azure – and I created the Minimal APIs in ASP.NET Core course.
> latest
23 min read
EF Core split queries with SingleOrDefaultAsync hide a LIMIT subquery PostgreSQL can't optimize. One extension method took an endpoint from 5.45s to 155ms.
12 min read
Learn how to validate options asynchronously at startup in .NET 11 with IAsyncValidateOptions and the new async Validate overloads, so your application fails fast when a configured endpoint is unreachable or misconfigured.
14 min read
Learn how to use C# 15 union types in ASP.NET Core 11 Minimal APIs. We declare unions, use exhaustive pattern matching, accept and return them as JSON, see how they show up in OpenAPI, and compare them with closed class hierarchies.
14 min read
Learn how to localize validation error messages and display names in .NET 11 Minimal APIs using the built-in localization support in Microsoft.Extensions.Validation, resource files, convention-based keys, and custom attributes.
13 min read
Learn how to use the new async validation support in .NET 11 Minimal APIs with AsyncValidationAttribute and IAsyncValidatableObject to run database-backed validation rules before your endpoint handlers even execute.
> explore
Hands-on guides to ASP.NET Core Minimal APIs: validation, endpoint filters, rate limiting, authentication, response types and clean endpoint organization.
Entity Framework Core in practice: query filters, concurrency control, split query performance and data access patterns.
Building on Microsoft Azure from .NET: Key Vault, Queue Storage, Azure OpenAI and Microsoft Graph.
Request validation in ASP.NET Core: built-in .NET validation, FluentValidation and async rules.
Unit testing in .NET: mocking configuration, the options pattern and writing readable tests.
Classic design patterns explained with practical C# examples.

> side project · founder
A running coaching platform I founded and built end-to-end. It turns an athlete’s Strava history into a personalised, periodised plan for their goal race.
> about me
I architect and build cloud-native business systems with .NET, PostgreSQL and Azure, and I share what works in production. Open to interesting backend problems, technical writing and collaborations.