Difference between IEnumerable & IQueryable

I have read lots of articles of difference between IEnumerable and IQueryable over internet and finally i got proper answer which i have written here

Both are using for data manipulation. IQueryable has all the features of IEnumerable. Both have its own significant for query data & data manipulation.

IEnumerable

• System.Collections is the Namespace for IEnumerable class.
• When Select Query On Server side at that time load data in-memory on client side then filter . suppose if we pass filter option in query like Top 10 or Max 5 then it will work on client side.
• It means after loading full data collections like list or array list data filter from there.

IQueryable

• System.Linq is the Namespace for IQueryable class.
• When Select Query On Server side data filter options will also handle in server side it means data will comes up with filtering done.
• IQueryable is best when using remote database.

In this article i try to explain IEnumerable and IQueryable difference. i hope this information will help you to understand the difference between both of them still if you have any query then you can post your feedback or comment.