Home Archive ASP.NET Core, EF Core, and Dapper pitfalls – .NET News Daily Issue #414 (Mar 18, 2026)

Editor's note

I curated a pretty practical mix this time: planning and architecture, performance, and the data-access gotchas that can quietly bite teams. The Dapper SQL Server index trap and the EF Core global query filters piece are especially worth a close read because both can change how your app behaves under load.

ASP.NET Core, EF Core, and Dapper pitfalls

Enjoying the newsletter? Your feedback helps us grow and reach more developers.

Share your testimonial →

Today's Articles

dotNetDave Says… Rushing into Coding Without Proper Planning Will Lead to Costly Mistakes and Delays

https://dotnettips.wordpress.com/2026/03/04/dotnetdave-says-rushing-into-coding-without-proper-planning-will-lead-to-costly-mistakes-and-delays/

Effective software projects require thorough planning and architecture before coding begins. Skipping these steps often leads to costly mistakes, delays, and technical debt. A strong foundation improv...

Article preview

Top 10 Software Development Trends in 2026 | Facile Technolab

https://www.faciletechnolab.com//blog/top-10-software-development-trends-in-2026/

Discover the Top 10 Software Development Trends in 2026. AI-native development, edge computing, DevSecOps, cloud-native strategies, sustainability, and practical steps to future-proof your software.

Article preview

Building High-Performance APIs with ASP.NET Core: A Practical Guide for Production

https://blog.stackademic.com/building-high-performance-apis-with-asp-net-core-a-practical-guide-for-production-9ce5c2e61ed9?source=rss------dotnet-5

Modern applications live and die by API performance. Slow endpoints increase infrastructure costs, reduce scalability, and hurt user… Continue reading on Stackademic »

Article preview

How C# Strings Silently Kill Your SQL Server Indexes in Dapper

https://consultwithgriff.com/dapper-nvarchar-implicit-conversion-performance-trap

A common Dapper pattern that causes SQL Server to ignore your indexes and scan entire tables.

Article preview

Demystifying Workflows with Microsoft Agent Framework

https://www.youtube.com/watch?v=2BB9-kWb1Tc

Article preview

Creating case-sensitive folders on Windows using C#

https://www.meziantou.net/creating-case-sensitive-folders-on-windows-using-csharp.htm

Windows has supported case-sensitive file operations for a long time, but it was not easily accessible or enabled by default. Since Windows 10 (version 1803), it is possible to enable case sensitivity...

Article preview

Splitting the NetEscapades.EnumGenerators packages: the road to a stable release

https://andrewlock.net/splitting-the-netescapades-enumgenerators-packages-the-road-to-a-stable-release/

In this post I describe the recent architectural changes to the NetEscapades.EnumGenerators package, which is now a metapackage, to support more scenarios

Article preview

How to Generate OTP in C#

https://www.c-sharpcorner.com/article/how-to-generate-otp-in-c-sharp/

Learn how to generate OTP (One-Time Password) in C# using both basic and secure methods. Implement secure authentication and verification in your applications.

Article preview

YARP as API Gateway in .NET: 7 Real-World Scenarios You Should Know

https://antondevtips.com/blog/yarp-as-api-gateway-in-dotnet

Master YARP as an API Gateway for your .NET microservices. This guide covers routing, load balancing, centralized security and authentication, path rewriting, Backend-for-Frontend (BFF) patterns, rate

Article preview

Demystifying .NET

https://shadhujan.medium.com/demystifying-net-4ef316b8f9e1?source=rss------dotnet-5

The Missing Manual for password security, understanding CPU vs. I/O-bound work, and why your password verification is pure synchronous…

Article preview

Global Query Filters in EF Core - Soft Delete, Multi-Tenancy & Named Filters in .NET 10

https://codewithmukesh.com/blog/global-query-filters-efcore/

Master global query filters in EF Core 10 with named filters, soft delete, multi-tenancy, IgnoreQueryFilters, and performance tips.

Article preview

FullJoin in .NET 11 - potentially

https://steven-giesel.com/blogPost/5a750fbf-cbf1-44dc-b864-70bedd8a29a9

We have Join. We have LeftJoin. We have RightJoin. But somehow we still don't have a proper full outer join in LINQ. That might come soon!

Article preview

5 New VS Code Features for Smarter Agents

https://www.youtube.com/watch?v=MvwcWWp1NFs

Article preview

AutoMapper 16.1 and MediatR 14.1 Released

https://www.jimmybogard.com/automapper-16-1-and-mediatr-14-1-released/

Today I released AutoMapper 16.1 and MediatR 14.1 (as part of now regular quarterly releases): AutoMapper Release Notes MediatR Release Notes AutoMapper added some interesting features, allowing for f...

Article preview

Hands On: Building an MCP Server with VS Code AI Toolkit's New Tool Catalog

https://visualstudiomagazine.com/Articles/2026/03/10/Building-an-MCP-Server-in-New-VS-Codes-New-Tool-Catalog-in-AI-Toolkit-Extension.aspx

Microsoft's AI Toolkit extension for VS Code now lets developers scaffold a working MCP server in minutes. Here's what that looks like in practice -- including the parts that don't work, and a simpler...

Article preview

Jasen's take on today's picks

dotNetDave Says… Rushing into Coding Without Proper Planning Will Lead to Costly Mistakes and Delays

A reminder that rushing into code is how teams buy technical debt before the first commit.

Top 10 Software Development Trends in 2026 | Facile Technolab

Good production guidance here on squeezing more from ASP.NET Core APIs without hand-waving.

Building High-Performance APIs with ASP.NET Core: A Practical Guide for Production

The Dapper and EF Core pieces are the kind of subtle data-layer articles that save hours later.

How C# Strings Silently Kill Your SQL Server Indexes in Dapper

YARP and the MCP server article show where .NET apps and tooling are heading next.

Demystifying Workflows with Microsoft Agent Framework

The EnumGenerators and LINQ join posts are nice reminders that the ecosystem keeps filling real gaps.

Related issues

📬 Get daily .NET content delivered to your inbox