Does LINQ skip and take decent performance?

Question

We have a query for about 40 customer related data fields. A query will often return a large number of records, say, up to 20,000. We want to use only about 500 results. Then we just want them to be able to scroll through them 10 at a time.

Is LINQ skipping and taking a reasonable approach for this? Are there any potential performance issues when using this approach, instead of doing it manually in some other way?

Answer 1

Take()without Skip()generates SQL using a clause TOP.

Take() Skip SQL ROW_NUMBER(), .

, LINQPad LINQ to SQL .

Answer 2

, SQL Server 2005+, SQL, ROW_NUMBER(), ( SQL, ).