iqueryable

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

by

[ad_1] 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 [ad_2] solved IQueryable with Entity Framework – order, where, skip and take … Read more

[Solved] IEnumreable and IQueryable [duplicate]

by

[ad_1] 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(); [ad_2] solved IEnumreable and IQueryable [duplicate]