So here we go, got a call yesterday from my agent saying that that company X wants me on board. Don’t know how I feel about it yet, but these guys seem to invest a lot in the new tech and the first time since 2002 I’m going to be working on a truly greenfield project. Damn, the vacation lasted only one week.
IEnumerable vs IQueriable
-IEnumerable exists in System.Collections Namespace.
-IEnumerable can move forward only over a collection, it can’t
move backward and between the items.
-IEnumerable is best to query data from in-memory collections like
List, Array etc.
-While query data from database, IEnumerable execute select query
on server side, load data in-memory on client side and then filter
-IEnumerable is suitable for LINQ to Object and LINQ to XML
-IEnumerable supports deferred execution.
-IEnumerable doesn’t supports custom query.
-IEnumerable doesn’t support lazy loading. Hence not suitable for
paging like scenarios.
-Extension methods supports by IEnumerable takes functional
MyDataContext dc = new MyDataContext ();
IEnumerable<Employee> list = dc.Employees.Where(p =>
list = list.Take<Employee>(10);
Generated SQL statements of above query will be :
SELECT [t0].[EmpID], [t0].[EmpName], [t0].[Salary] FROM [Employee]
WHERE [t0].[EmpName] LIKE @p0
Notice that in this query “top 10” is missing since IEnumerable
filters records on…
View original post 155 more words