Some time ago, a client needed some help optimizing a batch job for speed. The company provides analytics services for large global organizations in the automotive industry. They receive large amou...
In this article, I’ll describe how to implement soft delete in EF Core. We would like to apply a global configuration and not on a per-entity basis. The implementation consists of two parts, applyi...
In this article, I’ll go through a couple of implementations on how to extract and provide user information in ASP.NET Core web applications. We apply authentication and authorization to protect ou...
In .NET we have three patterns for asynchronous operations, Asynchronous Programming Model (APM), Event-based Asynchronous Pattern (EAP) and Task-based Asynchronous Pattern (TAP). Nowadays, the TAP...
When dealing with data that changes over time, you may want to keep track of historical changes. Temporal tables in SQL Server offer an excellent solution to this problem, allowing you to automatic...
EDIT: There are breaking changes in MediatR 12.0.1, and the following implementation won’t work. I’ll publish soon an updated implementation. The Mediator pattern is a behavioral design pattern t...
In this article I will explore the possibility of a subtle bug you may face in your application, if you’re using owned entity types and you have incorrect EF configuration. Let’s start with an exam...
EF Core allows you to model entity types that can only ever appear on navigation properties of other entity types. These are called owned entity types. By default, the owned entity types are mapped...
When working with web applications, you may occasionally need to convert HTML content into images or PDFs. In my case, I stumbled upon this requirement and, after a quick search, I discovered a fan...
I was recently asked about configuring a default convention in EF Core so that the generated table names use the entity names. Additionally, if a table name is set explicitly for a given entity (th...