asp.net mvc 3.0 从数据库中读取前十个数据

Question

public ActionResult Index() //主页{ var commoditys = from c in Context.Commoditys select c;commoditys = commoditys.Where(c => c.Category.CategoryName == "手机").OrderByDescending(c => c.CreateTime);//if (commoditys != null){return View(commoditys);}elsereturn RedirectToAction("error","home");}想要读取完成满足条件的前十个数据应该怎么做。？？？？

Answer 1

select top 10 * from 表名 order by ID asc