skip-take

LINQ TO SQL - Skip/Take not working as expected.

I've got an IQueryable repository (admittedly this is the first time I've tried this) and I can't seem to get it to pull the correct data using Skip(1).Take(1) Here's the repository Public Function GetActivity() As IQueryable(Of ActivityLog) Implements IActivityLogRepository.GetActivity Dim activity = (From a In dc.Activity...

Does LINQ skip & take have decent performance?

We have a query for about 40 data fields related to customers. The query will often return a large amount of records, say up to 20,000. We only want to use say around the first 500 results. Then, we just want to be able to page through them 10 at a time. Is LINQ skip and take a reasonable approach for this? Are there any potentnialy...