Converting an SQL from Sql Server to C#LINQ

Question

I have an sql that looks like this:

SELECT coluna1, coluna2, coluna3
  FROM
  (
      SELECT coluna1, coluna2, coluna3, ROW_NUMBER() OVER(ORDER BY coluna1, coluna3 desc) as row
       FROM tabela1
      WHERE coluna4 in ('a', 'b', 'c', 'd')
  ) A
 WHERE
        A.ROW BETWEEN 1 AND 5
ORDER BY  A.ROW

And I want to pass this instruction to C’s LINQ expression#.

Note: I am using ROW_NUMBER OVER(...) to be able to identify the line number and be able to do something similar to what you have in ORACLE: SELECT ... FROM ... limit 1,5

Answer 1

Your ROW_NUMBER() would be something equivalent to Top from what I understand. For this your query could use the Take which returns a specified number of contiguous elements from the beginning of a sequence.

Along with the Skip that ignores a specified number of elements in a sequence and returns the remaining elements.

So I try a pagination of your data.

var dados = (from t in tabela1
             where criterios....
            select new { Colunas....}).Skip(4).Take(5)