Sspipaliya8·11h agoEF Core Find vs FirstOrDefault: What's the Difference?Understand EF Core Find vs FirstOrDefault, Primary Key lookups, local tracking, SQL queries, performance, and practical C# examples.7 min read·sudhirpipaliya.hashnode.dev
GGANESH KUMAR·Oct 14EF Core with SQL Server, PostgreSQL, MySQL and SQLite in one codebaseSwitch EF Core database providers with one config value in ASP.NET Core 10: per-provider migrations, decimal precision, UTC dates and case-sensitive search.4 min read·rgk.hashnode.dev
Sspipaliya8·Oct 12EF Core Any vs Count: Which One Is Better for Existence Checks?Learn the difference between EF Core AnyAsync() and CountAsync() for existence checks, SQL translation, performance, indexes, and best practices.6 min read·sudhirpipaliya.hashnode.dev
Sspipaliya8·Oct 1IQueryable vs IEnumerable in C#: Key Differences Learn the difference between IQueryable and IEnumerable in C#, with practical EF Core examples, SQL execution, filtering, projection, and performance8 min read·sudhirpipaliya.hashnode.dev
Sspipaliya8·Sep 19EF Core Projection: How Select Can Improve Query PerformanceLearn how EF Core projection with Select reduces unnecessary data, improves API performance, and creates efficient database queries.17 min read·sudhirpipaliya.hashnode.dev
Sspipaliya8·Sep 14EF Core Include vs Select: Which One Should You Use?Learn when to use EF Core Include vs Select, how they affect SQL queries, performance, tracking, and when projection is a better choice.13 min read·sudhirpipaliya.hashnode.dev
Sspipaliya8·Sep 7EF Core Query Splitting vs Single Query: Which One Should You Use?Learn EF Core SingleQuery vs SplitQuery, cartesian explosion, Include performance, SQL generation, and when to use AsSplitQuery." slug: "ef-core-query-splitting-vs-single-query12 min read·sudhirpipaliya.hashnode.dev
Sspipaliya8·Sep 2Why Database Indexes Matter for EF Core PerformanceLearn how database indexes improve EF Core performance, composite indexes, execution plans, and common indexing mistakes in SQL Server.9 min read·sudhirpipaliya.hashnode.dev
Sspipaliya8·Aug 6Why Calling ToList() Too Early Can Hurt EF Core PerformanceLearn why calling ToList() too early can slow EF Core queries, increase memory usage, and how to write more efficient LINQ queries.5 min read·sudhirpipaliya.hashnode.dev
CCoding Droplets·Aug 4Unable to Create an Object of Type DbContext in EF Core: Causes and FixesUnable to create an object of type DbContext in EF Core? Here are the 6 real causes behind the design-time error and how to fix each one fast.12 min read·codingdroplets.com1