What is the difference between IEnumerable and IQueryable?

Question

Accepted Answer

**IEnumerable** — in-memory. **IQueryable** — remote execution. **IEnumerable:** - Client-side filtering. - Loads all data. - No SQL translation. **IQueryable:** - Server-side filtering. - Translates to SQL. - Efficient. ```csharp // IEnumerable — loads all IEnumerable all = context.Products; var filtered = all.Where(p => p.Price > 10); // In memory // IQueryable — SQL IQueryable query = context.Products; var filtered = query.Where(p => p.Price > 10); // SQL WHERE ``` **Key:** IQueryable for databases, IEnumerable for collections.

C#: What is the difference between IEnumerable and IQueryable?