Sspipaliya8insudhirpipaliya.hashnode.dev·17h ago · 13 min readEF 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 00
Sspipaliya8insudhirpipaliya.hashnode.dev·Sep 7 · 12 min readEF 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.Di00
Sspipaliya8insudhirpipaliya.hashnode.dev·Sep 2 · 9 min readWhy Database Indexes Matter for EF Core PerformanceEntity 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 performance00
PKPatrick Kearnsinfullstackcity.com·Sep 1 · 13 min readWhen AsNoTracking Makes EF Core SlowerThere is a piece of EF Core advice that appears in almost every performance discussion: If the query is read-only, use AsNoTracking(). Its usually good advice. Tracking entities requires EF Core to 01R
CDCoding Dropletsincodingdroplets.com·Aug 4 · 12 min readUnable to Create an Object of Type DbContext in EF Core: Causes and FixesYou add an entity, run dotnet ef migrations add AddOrders, and the tooling stops dead: Unable to create an object of type 'AppDbContext'. For the different patterns supported at design time, see https10
EAEugene Atinbireinayinenongre.hashnode.dev·Jul 28 · 4 min readHow I Reduced Build Time from Over 5 Minutes to Under 30 Seconds by Consolidating 400+ Entity Framework MigrationsAs developers, we often focus on optimizing application performance for our users, but we sometimes overlook something just as important our own developer experience. In our case, one of the biggest p00
Qqodorsinqodors.hashnode.dev·Jul 25 · 5 min readThe N+1 Query Problem in EF Core (And How to Spot It Before Production Does)A page that felt fine in testing is slow in production. Same code, same query, but now it crawls. You open the SQL log and there it is — not one query, but two hundred. One to load the list, then one 00
Qqodorsinqodors.hashnode.dev·Jul 22 · 6 min readEF Core Is Already a Repository. Stop Wrapping It in Another One.Open a lot of .NET projects and you'll find the repository pattern sitting on top of Entity Framework Core. IProductRepository, GetById, Add, Save, the whole set. Underneath, every method just calls t00
Qqodorsinqodors.hashnode.dev·Jul 10 · 5 min readAsNoTracking: The EF Core Setting Your Read Queries Are MissingMost of the queries in a typical app are reads. You fetch data, show it, and never change it. EF Core doesn't know that. By default it assumes every entity you load might be modified and saved back, s00
Qqodorsinqodors.hashnode.dev·Jul 9 · 6 min readIQueryable vs IEnumerable: The Mistake That Loads Your Whole TableYou wrote a clean LINQ query. It filters down to ten rows. It runs fine in dev, and then in production it's slow and your database CPU is higher than it should be for such a small result. The query lo00