Difference between IEnumerable vs IQueryable

Question

Hi all, What is the Main Difference between IEnumerable vs IQueryable.

Rajanikant Hawaldar · Answer

The main difference between “IEnumerable” and “IQueryable” is about where the filter logic is executed. One executes on the client side (in memory) and the other executes on the database For example, we have 10000 records for User in our database and let say only 900 out which are active users, so in this case if use “IEnumerable” approach then first it load all 10000 records in the memory then apply the IsActive filter on it which eventually returns the 900 active users.(Two steps process and load all the records in memory as well which will make the process slow) While on the other hand on the same case if we use “IQueryable” approach it will directly apply the IsActive filter on the database which directly from there will return the 900 active users.(One step process and will return less records which will be much faster). Have look here https://theprogressiveviews.blogspot.com/2016/05/some-best-practices-that-c-developer.html https://stackoverflow.com/questions/2433306/whats-the-difference-between-iqueryable-and-ienumerable sample article on “IEnumerable” and “IQueryable” https://www.c-sharpcorner.com/UploadFile/a20beb/ienumerable-vs-iqueryable-in-linq/

Difference between IEnumerable vs IQueryable

Answers (1)