We know that every Entity Framework Core (EF Core) LINQ query has a corresponding SQL query. That equivalent SQL is actually executed under the hood. Some LINQ expressions involve. NET-specific code, such as calling a method, using a reflection filter, or accessing files. You may have found several code blocks ...
Ali Hamza Ansari
Meet Ali, a talented .NET developer from Pakistan. Besides blogging, Ali works for a range of international customers doing everything from C# to Azure.
EF Core query translation: Why does some LINQ never become SQL?
Mapping database views in EF Core without breaking migrations
Entity Framework Core (EF Core) is working fine in your project. But the moment you use views, the migration gets messy. As a developer, I know any problem in the migration is haunting. You have to update and take care of other migrations so they don't get disturbed. ...
How .NET handles exceptions internally (and why they're expensive)
What really happens when you write throw new Exception() in .NET? Microsoft guidelines state that When a member throws an exception, its performance can be orders of magnitude slower. It's not just a simple jump to a catch block, but a lot goes in CLR (Common Language Runtime) ...
Designing business rules that don't leak into controllers
APIs are the engine of modern applications. Your product belongs to any domain, either medical, banking, or IoT, APIs are most probable bricks in it. Good, maintainable, and reusable code promises a functional system. While a bad one makes maintenance and testing tedious. There is so much to care about ...
When NOT to use the repository pattern in EF Core
If you design an application with a data source, the repository pattern often comes to mind as a prominent choice. In fact, many developers see it as the default choice. However, the pattern is not helping every time. In this post, I will pinpoint some cases where the repository pattern ...
Why IEnumerable Can Kill Performance in Hot Paths
For F1 racing, choosing the right car is as important as your expertise. No matter how skilled you are, if you race in an ordinary car, you can't stand out. You need to understand the race and use the F1 racing car. The same goes for programming. Going ...
Polymorphic Relationships in EF Core: Three Approaches
Database schema and entity design are the pavement of most applications. If the entities are paved well, the application can provide great performance. Otherwise, it can lead to pitfalls. One key aspect of entity design is dealing with polymorphic relationships. EF Core supports several ways to implement inheritance, so in ...
Implementing strongly-typed IDs in .NET for safer domain models
As developers, we know that user requests can be unpredictable. When they request data, it is either successfully returned or not found. However, a "not found" result usually happens in two ways. First, the user might request a record, such as a basketball player, by passing an ID ...
New in .NET 10 and C# 14: Multi-Tenant Rate Limiting
.NET 10 is officially out, along with C# 14. Microsoft has released .NET 10 as Long-Term Support (LTS) as a successor to .NET 8. Like every version, it is not just an update but brings something new to the table. In this series, we will explore which aspects of software ...