#efcore

Articles tagged with #efcore

EF Core Include vs Select: Which One Should You Use?
When working with Entity Framework Core, developers often use Include() to load related data. But there is another powerful approach: Select() So which one should you use? The answer depends on what
Sep 14, 202613 min read12
EF Core Query Splitting vs Single Query: Which One Should You Use?
Entity Framework Core makes it very easy to load related data using Include() and ThenInclude(). For example: var students = await context.Students .Include(x => x.Standard) .Include(x => x.Di
Sep 7, 202612 min read9
Why Database Indexes Matter for EF Core Performance
Entity Framework Core makes it easy to query data using LINQ. But even a well-written EF Core query can become slow when your database grows. One of the most important factors behind query performance
Sep 2, 20269 min read20
Why Calling ToList() Too Early Can Hurt EF Core Performance
If you've worked with Entity Framework Core, you've probably used ToListAsync() hundreds of times. There's nothing wrong with using it—but calling it too early in your query can significantly impact y
Aug 6, 20265 min read13
The Hidden Danger of MAX()+1 Logic in Enterprise Applications
Generating the next number using MAX() + 1 is one of the most common approaches developers use when creating custom identifiers. At first glance, the logic looks simple and perfectly valid: var maxZid
Jul 21, 20266 min read34