Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

Home Interviews What is the difference between IEnumerable, IQueryable, and List in C#? – MindStick
Ask Question

What is the difference between IEnumerable, IQueryable, and List in C#?

ICSM Computer 795 19 Jun 2025
c# c#
ICSM Computer
Ask by ICSM Computer
Updated 19 Jun 2025

1 Answers

ICSM Computer
ICSM Computer 19 Jun 2025
Report Abuse

What is the difference between IEnumerable, IQueryable, and List in C#?

  1. IEnumerable: Used to iterate over a collection. It executes queries in-memory (deferred execution).
  2. IQueryable: Supports LINQ queries with deferred execution, but translates them to SQL when working with databases like Entity Framework.
  3. List<T>: A concrete data structure that holds elements in memory with immediate execution.

Example:

IEnumerable<string> names = list.Where(x => x.StartsWith("A")); // in-memory
IQueryable<string> dbNames = dbContext.Users.Where(u => u.Name.StartsWith("A")); // SQL
advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md