need equivalent query in SQLite

Asked Jun 13 '13 at 05:57

Active Feb 05 '14 at 20:03

Viewed 38 times

what is the equivalent sqlite query of the following statement?

Data = _db.EMP_TRACKING.OrderBy(m => m.ID).Skip(page - 1).Take(PageSize)

What will be the query for the following scenario??

Say, I have table with 100000 rows. First I want select 1-100, then 101-200 ......

edited Feb 05 '14 at 20:03

BenMorel

asked Jun 13 '13 at 05:57

Can't you view generated SQL when you execute the statement, or just do `Data.ToString()`? And it should be `page x PageSize - 1`. – Gert Arnold Jun 13 '13 at 07:24

0 Answers0