| S.No | IEnumerable | IQuerable | |
| 1 | namespace | Sysem.Collection | System.LINQ |
| 2 | query data | in-memory collections like List, Array etc. | out-memory (like remote database, service) collections. |
| 3 | suitable | LINQ to Object and LINQ to XML queries. | LINQ to SQL queries |
| 4 | supports | custom query. | custom query using CreateQuery and Execute methods |
| 5 | Extension methods | IEnumerable takes functional objects. | expression objects means expression tree. |
Share Dot Net Experience