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);
}
else
return RedirectToAction("error","home");
}
想要读取完成满足条件的前十个数据应该怎么做。？？？？

Answer 1

select top 10 * from 表名 order by ID asc