The main difference between IEnumerable and IQueryable is IEnumerable executes a select query on the server-side, loads data in memory on the client side, and then filters data when querying data from a database

and

When querying data from a database, IQueryable executes the select query with all filters on the server-side.