how to write sql query in linq
how to write this query in linq ("select * from TblReg order by id OFFSET(" + (PageNumber - 1) * PAGESIZE + ") ROWS FETCH NEXT " + PAGESIZE + " ROWS ONLY ";)
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Bikesh SrivastavaPosted Nov 5, 2016, 11:12 PM
Rajeev PunhaniPosted Nov 5, 2016, 11:02 AM
Manas MohapatraPosted Nov 5, 2016, 10:40 AM
select rec).Skip((PageNumber - 1) * PAGESIZE).Take(PAGESIZE).ToList();
foreach (var reg in tempList)
Console.WriteLine(reg.PropertyName);