Urgent.News

What's breaking now, across thousands of outlets.

More in Tech

IQueryable vs IEnumerable: The Line Between C# and SQL

IQueryable vs IEnumerable: The Line Between C# and SQL You're filtering a million records. With one interface, the database does the work. With the other, your application drowns in memory.

  • IEnumerable evaluates filtering in application memory using delegates
  • IQueryable builds expression tree translated into SQL by database
  • Use IQueryable for large data sets and complex queries

More from Monday 21 September →