Wednesday 13 January 2021

IEnumerable vs IQueryable

 

The two interfaces IQueryable and IEnumerable seem almost interchangeable. Here I discuss one of the key differences, and how it can have a serious effect on performance.

Topics include:

  • C#
  • IQueryable<T>
  • IEnumerable<T>
  • Extension methods
  • Entity Framework
  • SQL
  • Performance
  • Deferred execution
Related videos:

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

The State Pattern

  How many developers does it take to change a lightbulb? With the State pattern, not very many. Topics include: The State Pattern Design Pa...

  • Sharpen Up Your Code
      I've been vlogging about all things C# and .NET related for a while now, and I thought that where sometimes a picture paints a thousan...
  • EF Core In-Memory DB Best Practices
      In-memory databases are great for unit testing, but tread carefully if you want to avoid false positives - and worse, false negatives. Top...
  • Implementing IEnumerable
    The C# foreach loop works on any standard collection, but what do we need to do to make it work on collections we've written for oursel...