Entity的动态where应该如何写啊？？

[lijing3333]

 public List<NyUsers> Page(int pagesize, int pageindex, NyUsers model)
        {
            try
            {
              
                int skcount = (pageindex - 1) * pagesize;
                var db = new nanyouEntities();
                var query = xxx;

                if (string.IsNullOrEmpty(model.username))
                   query = xxx;

                IEnumerable<NyUsers> list = db.NyUsers.Where(m => query ).OrderByDescending(c => c.userid).Skip(skcount).Take(pagesize);
                return list.ToList();
            }
            catch (Exception ex)
            {
                throw ex.InnerException;
            }
        }

这里的query我应该怎么拼接啊??? 求教 。。。

[superliu1122]

int skcount = (pageindex - 1) * pagesize;
var db = new nanyouEntities();
var query = db.NyUsers.Where(m => m.xxx==model.xxx);
 
if (string.IsNullOrEmpty(model.username))
   query = query.Where(m => m.username==model.username);
 
IEnumerable<NyUsers> list = query.OrderByDescending(c => c.userid).Skip(skcount).Take(pagesize);
return list.ToList();

[H_Gragon]

你吧where那写成sql 语句不行吗？