linq to sql 怎么查前5条记录

linq method：

var users = Users.OrderBy(u=>u.UserName).Take(5)

linq expression我就不会了，呵呵。

select top 10 * from TableA A where A.id not in (select top 10 id from TableA order by id ) order by id

TableA.OrderBy(item =>item.id).Skip(10).Take(10)

---