How to make "select not in" clause using linq sql
Solution 1:
TOP
makes no sense without an ORDER BY
.
Assuming you're paging the results sorted by the customer ID, try:
List<Customer> page = context.Customers
.OrderBy(c => c.CustomerID)
.Skip(3).Take(3)
.ToList();