If database doesn't support offset/limit in SQL NReco.Data handles this on its side (skips first N rows for offset, and reads only rows according to the limit specified in the Query).
However, when DbDataReader.ApplyOffset = true ExecuteReader() ignores Query.RecordOffset / Query.RecordCount properties which is not consistent with other methods like ToList() ToDictionaryList() etc.
VitaliyMF
commented
4 years ago
If database doesn't support offset/limit in SQL NReco.Data handles this on its side (skips first N rows for offset, and reads only rows according to the limit specified in the Query).
However, when DbDataReader.ApplyOffset = true ExecuteReader() ignores Query.RecordOffset / Query.RecordCount properties which is not consistent with other methods like ToList() ToDictionaryList() etc.