Entity Framework: IQueryable vs. IEnumerable
Found a great post on this, with example .. Entity Framework: IQueryable vs. IEnumerable Many of us sometimes get confused of different aspects of using IEnumerable < T > and IQueryable < T > in Entity Framework. One of considered opinions is that Entity Framework and DbContext and deffered execution just do all the magic and there is no difference. ... But even though LINQ query result remains basically the same, it may significantly impact the query performance. http://ivanitskyi.blogspot.ca/2013/04/entity-framework-iqueryable-vs-ienumerable.html Hope it is helpful for the team. Cheers Kam