How to make "select not in" clause using linq sql

Question

I am making a sql query and I want to have the linq sql syntax.

Query SQL:

SELECT TOP 3 * FROM Customer
WHERE CustomerID NOT IN (SELECT TOP 3 CustomerID FROM Customer ORDER BY CustomerID)

Please suggest a solution.

Thanks!

explain more by add new and complete info, more people can help u — AmirHossein
– AmirHossein, Commented Jan 11, 2022 at 9:27

Richard Deeming · Accepted Answer · 2022-01-11 09:29:03Z

3

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();

answered Jan 11, 2022 at 9:29

Richard Deeming

31.5k11 gold badges86 silver badges167 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1