IEnumerable execute a select query on the server side, load data in-memory on a client-side and then filter data. IQueryable execute the select query on the server side with all filters
difference between iqueryable and ienumerable