I'm using Entity Framework (code first) like this:
IQueryable<StammdatenEntityModel> query = dbSet;
query.OrderByDescending(s => s.CreateDateTime);
query.Where(s => s.Deleted == false);
if(!String.IsNullOrEmpty(keyword))
{
query.Where(s => s.SerialNumber.Contains(keyword)); //simplified for SO
}
query.Skip(skip);
query.Take(take);
However the OrderByDescending
, Where
, Skip
and Take
don't have any effect.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…