The science of collection and manipulation

11:06 PM Lokesh kumar 0 Comments


This is highly conducive to iterating via collections. Ienumerable forms radically an interface which describes the singular mode GetEnumerator. This mode gives back an Ienumerator interface pertaining to the wanted class. The Ienumerator interface makes easy “read only” access towards collections and permits iteration amid the type by seeking the assistance of a for-each loop. Next, the assortment that executes the IEnumerable mode shall be employed in favour of the coding for-each statements. Within C#, IEnumerable builds the abstract combined with Ienumerator happens to be the abstract Iterator. The IEnumerable shall be executed by assortments like lists. To state it in an easy form, IEnumerable pertains to iteration above uncommon collections. It constitutes the base interface in favour of enumerators.In Linq, both of these processes have got a huge role to play and support each other.


IEnumerable and Iqueryable can be said to be interfaces that make possible the query collection and also manipulation of data. Whenever Iqueryable happens to be inherited by IEnumerable, here Iqueryable incorporates its characteristics to IEnumerable interfaces to assist query and manipulate the assortment of data. Whenever IEnumerable tends to be inherited by Iqueryable, it in actuality, implies that Iqueryable showers its traits on the IEnumerable interface. Every time developers need to handle large data enclosing a lot of records, Iqueryable displays elevated performance by filtering data prior to conveying the filtered information towards customers.

Difference amid two

It is necessary to shed light on the prime difference between IEnumerable and Iqueryable that can be associated with the place in which the filter logic may be implemented. While the IEnumerable is implemented over the client side inside memory sites, Iqueryable can be implemented on databases.

IEnumerable shall be discovered within the system. Collections namespace while Iqueryable governs the system. Linq Namespace

IEnumerable makes the better employed for querying information from the in-memory assortments pertaining to the comparables of Arrays, lists and a lot more. Conversely, Iqueryable can be utilised for querying information from distant services, databases, and other out-memory collections.

Within the course of querying information from databases, IEnumerable tends to run the “select query” which prevails over the server-side; this feeds the data in –memory irregularly over the client-side, and after that advances to filter the information. In opposition to this, Iqueryable implements the “select query” having the whole of the filters over the server-side.

IEnumerable can be taken to be supportive for dealing with the LINQ to the entity and also LINQ to XML questions. Moreover, Iqueryable may be thought to be supportive for tackling LINQ to SQL questions.

IEnumerable tends to be slow as it is about its processing pace on the ground during the instant of selecting information from databases it is inclined to implement the select question over the server-side, feed the information in-memory successfully over the client-side and afterwards advance towards the method of filtering information. It cannot be applied to Iquerytable.

IEnumerable is preferred primarily for small information manipulations while Iqueryable is supportive for carrying out big-sized information manipulation tasks.