[Solved] IQueryable with Entity Framework – order, where, skip and take have no effect

You are not using the result of query IQueryable<StammdatenEntityModel> query = dbSet; query = query.OrderByDescending(s => s.CreateDateTime); query = query.Where(s => s.Deleted == false); if(!String.IsNullOrEmpty(keyword)) { query = query.Where(s => s.SerialNumber.Contains(keyword)); //simplified for SO } query = query.Skip(skip); query = query.Take(take); 0 solved IQueryable with Entity Framework – order, where, skip and take have no … Read more

[Solved] IEnumreable and IQueryable [duplicate]

When querying a database, I prefer using a IQueryable because the request is sent when data are needed. I mean this var users = (from user in db.Users select user ).AsQueryable(); //it doesn’t load data yet until you write users.ToList(); or users.Count(); solved IEnumreable and IQueryable [duplicate]