Click here to Skip to main content
13,861,621 members
Click here to Skip to main content
Add your own
alternative version

Tagged as


31 bookmarked
Posted 29 Apr 2014
Licenced CPOL

IEnumerable vs IQueryable

, 29 Apr 2014
Rate this:
Please Sign up or sign in to vote.
IEnumerable vs IQueryable?

Both these interfaces are for .NET collections, so if you are new to .NET collection please first see this video before moving ahead with the article.

The first important point to remember is “IQueryable” interface inherits from “IEnumerable”, so whatever “IEnumerable” can do, “IQueryable” can also do.

There are many differences but let us discuss about the one big difference which makes the biggest difference. “IQueryable” interface is useful when your collection is loaded using LINQ or Entity framework and you want to apply filter on the collection.

Consider the below simple code which uses “IEnumerable” with entity framework. It’s using a “where” filter to get records whose “EmpId” is “2”.

IEnumerable<Employee> emp = ent.Employees;

IEnumerable<Employee> temp = emp.Where(x => x.Empid == 2).ToList<Employee>();

<empentities ent="new" />

This where filter is executed on the client side where the “IEnumerable” code is. In other words, all the data is fetched from the database and then at the client it scans and gets the record with “EmpId” is “2”.

But now see the below code we have changed “IEnumerable” to “IQueryable”.

IQueryable<Employee> emp = ent.Employees;

IEnumerable<Employee> temp = emp.Where(x => x.Empid == 2).ToList<Employee>();

In this case, the filter is applied on the database using the “SQL” query. So the client sends a request and on the server side, a select query is fired on the database and only necessary data is returned.

So the difference between “IQueryable” and “IEnumerable” is about where the filter logic is executed. One executes on the client side and the other executes on the database.

So if you are working with only in-memory data collection “IEnumerable” is a good choice but if you want to query data collection which is connected with database, “IQueryable” is a better choice as it reduces network traffic and uses the power of SQL language.

Below is a nice FB video which demonstrates this blog in a more visual and practical manner.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

You may also be interested in...

Comments and Discussions

QuestionDoes the declaring IQueryable as IEnumerable really change the behavior? Pin
Joe Bakerr7-Dec-17 6:45
memberJoe Bakerr7-Dec-17 6:45 
GeneralMy vote of 5 Pin
Carmelo Campione6-Jan-16 13:27
memberCarmelo Campione6-Jan-16 13:27 
QuestionIQueryable vs IEnumerable Pin
nasirkhayam4-Jun-15 20:56
membernasirkhayam4-Jun-15 20:56 
Generalmy vote 5.. it really helpful Pin
ravikirand12314-Feb-15 21:04
memberravikirand12314-Feb-15 21:04 
GeneralThanks. It was really helpful. Pin
RonakC26-Jan-15 3:15
memberRonakC26-Jan-15 3:15 
GeneralMy vote of 4.5 Pin
Malhotra Sameer18-Jan-15 1:05
professionalMalhotra Sameer18-Jan-15 1:05 
GeneralMy vote 5 Pin
Amey K Bhatkar29-Apr-14 18:07
memberAmey K Bhatkar29-Apr-14 18:07 
GeneralMy vote of 3 Pin
michmela4429-Apr-14 7:16
membermichmela4429-Apr-14 7:16 
GeneralRe: My vote of 3 Pin
Shivprasad koirala29-Apr-14 7:27
memberShivprasad koirala29-Apr-14 7:27 
GeneralRe: My vote of 3 Pin
michmela4429-Apr-14 7:34
membermichmela4429-Apr-14 7:34 
GeneralRe: My vote of 3 Pin
Shivprasad koirala29-Apr-14 8:32
memberShivprasad koirala29-Apr-14 8:32 
GeneralMy vote of 5 Pin
Thiago Romam29-Apr-14 5:56
professionalThiago Romam29-Apr-14 5:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web06 | 2.8.190214.1 | Last Updated 29 Apr 2014
Article Copyright 2014 by Shivprasad koirala
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid