linq-to-sql - Linq to SQL 中相当于 TOP 或 LIMIT/OFFSET 的是什么？

Question

我该怎么做

Select top 10 Foo from MyTable

在 Linq to SQL 中？

Answer 1

使用Take method :

var foo = (from t in MyTable
           select t.Foo).Take(10);

在 VB LINQ 中有一个 take 表达式:

Dim foo = From t in MyTable _
          Take 10 _
          Select t.Foo

来自文档:

Take<TSource> enumerates source and yields elements until count elements have been yielded or source contains no more elements. If count exceeds the number of elements in source, all elements of source are returned.