---
title: "Discussion on \"IQueryable vs IEnumerable: The Mistake That Loads Your Whole Table\" | Hashnode"
description: "Discussion on \"IQueryable vs IEnumerable: The Mistake That Loads Your Whole Table\". Why the wrong return type loads your entire table into memory — and how to filter in SQL instead."
url: "https://hashnode.com/posts/iqueryable-vs-ienumerable-the-mistake-that-loads-your-whole-table/6a4f782cdfe8165329ff8546"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [IQueryable vs IEnumerable: The Mistake That Loads Your Whole Table](https://qodors.hashnode.dev/iqueryable-vs-ienumerable-the-mistake-that-loads-your-whole-table?utm_source=hashnode&utm_medium=feed)

Why the wrong return type loads your entire table into memory — and how to filter in SQL instead.

Jul 9 · 6 min read · qodors.hashnode.dev  
Read the article

-   [#dotnet](https://hashnode.com/tag/dotnet)
-   [#csharp](https://hashnode.com/tag/csharp)
-   [#efcore](https://hashnode.com/tag/efcore)
-   [#linq](https://hashnode.com/tag/linq)
-   [#entity-framework](https://hashnode.com/tag/entity-framework)

## Written by

[qodors](https://hashnode.com/@qodors)

@qodors · Bangalore, India

  
[View profile](https://hashnode.com/@qodors)

if you’re building or scaling a product, need to fix AI-generated or incomplete systems, or want a reliable engineering team. We help turn i

if you’re building or scaling a product, need to fix AI-generated or incomplete systems, or want a reliable engineering team. We help turn ideas into stable, production-ready software.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
