pipaliya sudhir

.NET Developer | Backend Engineer | Technical Blogger 🚀
C# • Core • EF Core • SQL Server
Sharing real-world .NET, performance & database insights.

[pipaliya sudhir @spipaliya13]

🚀 New Article

EF Core Projection: How Select Can Improve Query Performance

Learn how Select() can reduce unnecessary data loading, generate more focused SQL, and improve EF Core query performance.

🔗 https://t.co/d58ua4oA6Q

#dotnet #EFCore #Entityframework #EF #SQL

[pipaliya sudhir @spipaliya13]

🚀 New Blog #8!

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

Learn when to use Include(), when Select() is better, and how projection can improve EF Core API performance.

👉 Read: https://t.co/rH4EIBYzuG

#DotNet #EFCore #CSharp #SQLServer

[pipaliya sudhir @spipaliya13]

In this article:
🔹 Single Query vs Split Query
🔹 AsSingleQuery() & AsSplitQuery()
🔹 Cartesian explosion
🔹 Split Query vs N+1
📖 Read the full article on Hashnode:
https://t.co/mX4bSJp3ZY

#dotnet #EFCore #EntityFramework #SQLServer #CSharp #BackendDevelopment #Performance

[pipaliya sudhir @spipaliya13]

🚀 New Blog Post

Why Database Indexes Matter for EF Core Performance
In this article:
🔹 Indexes & EF Core
🔹 Composite indexes
🔹 Index column order
🔹 Foreign key indexes
🔹 Execution plans
🔹 Common indexing mistakes
👉 Read the full article:
https://t.co/16SGmL16GH

[pipaliya sudhir @spipaliya13]

🚀 10 Common LINQ Mistakes That Hurt EF Core Performance
Small LINQ mistakes can lead to:
❌ Unnecessary DB queries
❌ High memory usage
❌ Excessive data transfer
❌ Slow application performance
🔗 https://t.co/lVGeXUii9K
#dotnet #EFCore #LINQ #CSharp #ASPNetCore #SQLServer

[pipaliya sudhir @spipaliya13]

Many EF Core performance issues start with one small mistake:

It loads unnecessary data into memory, increases network traffic, and slows down your application.

🔗 https://t.co/D8DCFAHz9F

#dotnet #EFCore #csharp #aspnet #performance #sqlserver

[pipaliya sudhir @spipaliya13]

ExecuteUpdateAsync() or SaveChangesAsync()?

Both have different use cases, and choosing the wrong one can affect performance.

I compared both with practical examples and best practices.

🔗https://t.co/I4Vg6xosvU

#dotnet #EFCore #csharp #performance #aspnet

[pipaliya sudhir @spipaliya13]

Generating IDs using MAX()+1 looks simple...

Until two users insert data at the same time.

Here's why this approach causes race conditions and how to avoid it.

🔗 https://t.co/ePIh0521xD

#sqlserver #dotnet #database #EFCore

[pipaliya sudhir @spipaliya13]

A single method can improve the performance of your EF Core queries.

AsNoTracking() reduces memory usage and avoids unnecessary change tracking for read-only operations.

Learn when to use it.

🔗 https://t.co/GIIFzDBBMq

#EFCore #dotnet #performance #csharp