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

Question

ICSM Computer · Answer

What is the difference between IEnumerable,
IQueryable, and List in C#?
IEnumerable: Used to iterate over a collection. It executes queries in-memory (deferred execution).IQueryable: Supports LINQ queries with deferred execution, but translates them to SQL when working with databases like Entity Framework.Listandlt;Tandgt;: A concrete data structure that holds elements in memory with immediate execution.
Example:
IEnumerableandlt;stringandgt; names = list.Where(x =andgt; x.StartsWith("A")); // in-memory
IQueryableandlt;stringandgt; dbNames = dbContext.Users.Where(u =andgt; u.Name.StartsWith("A")); // SQL

interview

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

ICSM Computer

Can you answer this question?

1 Answers

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

Liked By