IEnumerable — in-memory. IQueryable — remote query.
1// IEnumerable — in-memory2IEnumerable<int> numbers = new List<int> {1, 2, 3, 4, 5};3var result = numbers.Where(x => x > 2);4// Executes in memory56// IQueryable — database7IQueryable<User> users = dbContext.Users;8var result = users.Where(u => u.Age > 18);9// Executes as SQL in database