---
title: "spipaliya8 (@spipaliya) | Hashnode"
description: "Real-world .NET, SQL Server and ERP engineering insights. Read the latest articles by spipaliya8 on Hashnode."
url: "https://hashnode.com/@spipaliya"
---

@spipaliya

# spipaliya8

@spipaliya · Surat, India · Joined July 2026

Real-world .NET, SQL Server and ERP engineering insights.

### [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)

[5d ago](https://hashnode.com/posts/ef-core-find-vs-firstordefault-what-s-the-difference/6afaa958914a94e8561ad5c4)

### [FirstOrDefault vs SingleOrDefault in EF Core: Which One Should You Use?](https://sudhirpipaliya.hashnode.dev/firstordefault-vs-singleordefault-in-ef-core-which-one-should-you-use?utm_source=hashnode&utm_medium=feed)

Understand FirstOrDefault vs SingleOrDefault in EF Core, including SQL translation, performance, exceptions, and best practices.

7 min read · [sudhirpipaliya.hashnode.dev](https://sudhirpipaliya.hashnode.dev/firstordefault-vs-singleordefault-in-ef-core-which-one-should-you-use?utm_source=hashnode&utm_medium=feed)

[Nov 2](https://hashnode.com/posts/firstordefault-vs-singleordefault-in-ef-core-which-one-should-you-use/6ae829b2e936852fa7774437)

### [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)

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

### [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)

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

### [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)

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