The Highest Post






=
Statistics
Count 94
Avg 21.00
Min 21
Max 21

Details



Peter Agyekum Difference between IEnumerable,IQueryable IEnumerable exists in System.Collections Namespace. 2. IEnumerable can move forward only over a collection, it can’t move backward and between the items. 3. IEnumerable is best to query data from in-memory collections like List, Array etc. 4. While query data from database, IEnumerable execute select query on server side, load data in-memory on client side and then filter data. 5. IEnumerable is suitable for LINQ to Object and LINQ to XML queries. 6. IEnumerable supports deferred execution. 7. IEnumerable doesn’t supports custom query. IQueryable exists in System.Linq Namespace. 2. IQueryable can move forward only over a collection, it can’t move backward and between the items. 3, IQueryable is best to query data from out-memory (like remote database, service) collections. 4. While query data from database, IQueryable execute select query on server side with all filters. 5. IQueryable is suitable for LINQ to SQL queries. 6. IQueryable supports deferred execution. 7. IQueryable supports custom query using CreateQuery and Execute methods.
Post Reply