---
title: "#efcore articles | Hashnode"
description: "Explore 129 articles tagged #efcore on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/efcore"
---

Tag

# #efcore

129 posts · 16 followers

[spipaliya8](https://hashnode.com/@spipaliya) · [11h ago](https://hashnode.com/posts/ef-core-find-vs-firstordefault-what-s-the-difference/6afaa958914a94e8561ad5c4)

### [EF Core Find vs FirstOrDefault: What's the Difference?](https://sudhirpipaliya.hashnode.dev/ef-core-find-vs-firstordefault-what-s-the-difference?utm_source=hashnode&utm_medium=feed)

Understand EF Core Find vs FirstOrDefault, Primary Key lookups, local tracking, SQL queries, performance, and practical C# examples.

7 min read · [sudhirpipaliya.hashnode.dev](https://sudhirpipaliya.hashnode.dev/ef-core-find-vs-firstordefault-what-s-the-difference?utm_source=hashnode&utm_medium=feed)

[GANESH KUMAR](https://hashnode.com/@rgk) · [Oct 14](https://hashnode.com/posts/ef-core-with-sql-server-postgresql-mysql-and-sqlite-in-one-codebase/6acfc4fbf9b7f4e7a9884704)

### [EF Core with SQL Server, PostgreSQL, MySQL and SQLite in one codebase](https://rgk.hashnode.dev/ef-core-with-sql-server-postgresql-mysql-and-sqlite-in-one-codebase?utm_source=hashnode&utm_medium=feed)

Switch 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](https://rgk.hashnode.dev/ef-core-with-sql-server-postgresql-mysql-and-sqlite-in-one-codebase?utm_source=hashnode&utm_medium=feed)

[spipaliya8](https://hashnode.com/@spipaliya) · [Oct 12](https://hashnode.com/posts/ef-core-any-vs-count-which-one-is-better-for-existence-checks/6accd3086f31e7b96fe57492)

### [EF Core Any vs Count: Which One Is Better for Existence Checks?](https://sudhirpipaliya.hashnode.dev/ef-core-any-vs-count-which-one-is-better-for-existence-checks?utm_source=hashnode&utm_medium=feed)

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](https://sudhirpipaliya.hashnode.dev/ef-core-any-vs-count-which-one-is-better-for-existence-checks?utm_source=hashnode&utm_medium=feed)

[spipaliya8](https://hashnode.com/@spipaliya) · [Oct 1](https://hashnode.com/posts/iqueryable-vs-ienumerable-in-c-key-differences/6abe5890be31b354fdb99f01)

### [IQueryable vs IEnumerable in C#: Key Differences](https://sudhirpipaliya.hashnode.dev/iqueryable-vs-ienumerable-in-c-key-differences?utm_source=hashnode&utm_medium=feed)

Learn the difference between IQueryable and IEnumerable in C#, with practical EF Core examples, SQL execution, filtering, projection, and performance

8 min read · [sudhirpipaliya.hashnode.dev](https://sudhirpipaliya.hashnode.dev/iqueryable-vs-ienumerable-in-c-key-differences?utm_source=hashnode&utm_medium=feed)

[spipaliya8](https://hashnode.com/@spipaliya) · [Sep 19](https://hashnode.com/posts/ef-core-projection-how-select-can-improve-query-performance/6aae0bd80263eba28e6b8b92)

### [EF Core Projection: How Select Can Improve Query Performance](https://sudhirpipaliya.hashnode.dev/ef-core-projection-how-select-can-improve-query-performance?utm_source=hashnode&utm_medium=feed)

Learn how EF Core projection with Select reduces unnecessary data, improves API performance, and creates efficient database queries.

17 min read · [sudhirpipaliya.hashnode.dev](https://sudhirpipaliya.hashnode.dev/ef-core-projection-how-select-can-improve-query-performance?utm_source=hashnode&utm_medium=feed)

[spipaliya8](https://hashnode.com/@spipaliya) · [Sep 14](https://hashnode.com/posts/ef-core-include-vs-select-which-one-should-you-use/6aa7d6a2bd87506b546c7106)

### [EF Core Include vs Select: Which One Should You Use?](https://sudhirpipaliya.hashnode.dev/ef-core-include-vs-select-which-one-should-you-use?utm_source=hashnode&utm_medium=feed)

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](https://sudhirpipaliya.hashnode.dev/ef-core-include-vs-select-which-one-should-you-use?utm_source=hashnode&utm_medium=feed)

[spipaliya8](https://hashnode.com/@spipaliya) · [Sep 7](https://hashnode.com/posts/ef-core-query-splitting-vs-single-query-which-one-should-you-use/6a9ea4eba05f3609822f73d7)

### [EF Core Query Splitting vs Single Query: Which One Should You Use?](https://sudhirpipaliya.hashnode.dev/ef-core-query-splitting-vs-single-query-which-one-should-you-use?utm_source=hashnode&utm_medium=feed)

Learn EF Core SingleQuery vs SplitQuery, cartesian explosion, Include performance, SQL generation, and when to use AsSplitQuery." slug: "ef-core-query-splitting-vs-single-query

12 min read · [sudhirpipaliya.hashnode.dev](https://sudhirpipaliya.hashnode.dev/ef-core-query-splitting-vs-single-query-which-one-should-you-use?utm_source=hashnode&utm_medium=feed)

[spipaliya8](https://hashnode.com/@spipaliya) · [Sep 2](https://hashnode.com/posts/why-database-indexes-matter-for-ef-core-performance/6a981dd026c67c2088054ab5)

### [Why Database Indexes Matter for EF Core Performance](https://sudhirpipaliya.hashnode.dev/why-database-indexes-matter-for-ef-core-performance?utm_source=hashnode&utm_medium=feed)

Learn how database indexes improve EF Core performance, composite indexes, execution plans, and common indexing mistakes in SQL Server.

9 min read · [sudhirpipaliya.hashnode.dev](https://sudhirpipaliya.hashnode.dev/why-database-indexes-matter-for-ef-core-performance?utm_source=hashnode&utm_medium=feed)

[spipaliya8](https://hashnode.com/@spipaliya) · [Aug 6](https://hashnode.com/posts/why-calling-tolist-too-early-can-hurt-ef-core-performance/6a740d76bb40b8bee125d8b5)

### [Why Calling ToList() Too Early Can Hurt EF Core Performance](https://sudhirpipaliya.hashnode.dev/why-calling-tolist-too-early-can-hurt-ef-core-performance?utm_source=hashnode&utm_medium=feed)

Learn 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](https://sudhirpipaliya.hashnode.dev/why-calling-tolist-too-early-can-hurt-ef-core-performance?utm_source=hashnode&utm_medium=feed)

[Coding Droplets](https://hashnode.com/@codingdroplets) · [Aug 4](https://hashnode.com/posts/ef-core-unable-create-dbcontext-design-time/6a71d44f2a2449e858cadc13)

### [Unable to Create an Object of Type DbContext in EF Core: Causes and Fixes](https://codingdroplets.com/ef-core-unable-create-dbcontext-design-time?utm_source=hashnode&utm_medium=feed)

Unable 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.com](https://codingdroplets.com/ef-core-unable-create-dbcontext-design-time?utm_source=hashnode&utm_medium=feed)
