Tag

#efcore

128 posts16 followers

Explore Hashnode

Alternatives

GANESH KUMAROct 14 · 4 min read

EF Core with SQL Server, PostgreSQL, MySQL and SQLite in one codebase

When I moved eCommerceMVCCore, my ASP.NET Core e-commerce project, to .NET 10, I wanted buyers to use whichever database they already run. Agencies often have a SQL Server licence, startups like Postg

rgk.hashnode.dev

spipaliya8Oct 12 · 6 min read

EF Core Any vs Count: Which One Is Better for Existence Checks?

When working with Entity Framework Core (EF Core), we often need to check whether a record exists in the database. For example: Does a student already exist? Has an email address already been regist

sudhirpipaliya.hashnode.dev

spipaliya8Oct 1 · 8 min read

IQueryable vs IEnumerable in C#: Key Differences

When working with collections in C#, you will often come across two important interfaces: IEnumerable<T> IQueryable<T> They may look similar because both allow you to query collections using LINQ.

sudhirpipaliya.hashnode.dev

spipaliya8Sep 19 · 17 min read

EF Core Projection: How Select Can Improve Query Performance

When working with Entity Framework Core, one of the easiest ways to accidentally retrieve more data than necessary is to load complete entities. For example: var students = await context.Students

sudhirpipaliya.hashnode.dev

spipaliya8Sep 14 · 13 min read

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

sudhirpipaliya.hashnode.dev

spipaliya8Sep 7 · 12 min read

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

sudhirpipaliya.hashnode.dev

spipaliya8Sep 2 · 9 min read

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

sudhirpipaliya.hashnode.dev

spipaliya8Aug 6 · 5 min read

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

sudhirpipaliya.hashnode.dev

FantasyDynastyDevAug 5 · 7 min read

Modeling the NBA salary cap as a rules engine: dead money, RFA, and the apron

I've spent the last while building a fantasy basketball platform (Fantasy Dynasty — my project, so calibrate accordingly), and the fantasy-scoring part turned out to be the boring bit. The genuinely h

fantasy-dynasty.hashnode.dev

Coding DropletsAug 4 · 12 min read

Unable to Create an Object of Type DbContext in EF Core: Causes and Fixes

You 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 https

codingdroplets.com

Search Hashnode

Explore Hashnode

Trending tags this week

EF Core with SQL Server, PostgreSQL, MySQL and SQLite in one codebase

EF Core Any vs Count: Which One Is Better for Existence Checks?

IQueryable vs IEnumerable in C#: Key Differences

EF Core Projection: How Select Can Improve Query Performance

EF Core Include vs Select: Which One Should You Use?

EF Core Query Splitting vs Single Query: Which One Should You Use?

Why Database Indexes Matter for EF Core Performance

Why Calling ToList() Too Early Can Hurt EF Core Performance

Modeling the NBA salary cap as a rules engine: dead money, RFA, and the apron

Unable to Create an Object of Type DbContext in EF Core: Causes and Fixes