Go from Linq to Sql

Question

Go from Linq to Sql

Navigation

#1 by (1 votes)

0

I have the following expression from Linq:

Tabla.Skip(ind_pag).Take(cant_filas).ToList()

How would it be on MySql ???

mysql linq asp.net linq-to-sql

asked by Danilo 21.08.2016 в 00:13

source

1 answer

How to select only the first records of a ranking when there are several ranking groups from a procedure stored in MySQL? How to send a json to a view with ASP .NET MVC

score 1 · Accepted Answer

That is a query with paging, the Skip and Take methods indicate how many rows to skip and how many to select respectively. In MySQL this is expressed with LIMIT

SELECT columna1, columna2, ...
FROM Tabla
LIMIT @ind_pag, @cant_filas