how to write sql query in linq

Question

how to write this query in linq (select * from TblReg order by id OFFSET( + (PageNumber - 1) * PAGESIZE + ) ROWS FETCH NEXT  + PAGESIZE +  ROWS ONLY ;)

Bikesh Srivastava · Answer

If you are not able integrate query in linq just type inline query.

Rajeev Punhani · Answer

Hi Asad Please see the below snippet. (from p in TblReg orderby p.id select p ).Skip((page - 1) * pageSize).Take(pageSize)

Manas Mohapatra · Answer

Try like below: var tempList = (from rec in tblReg select rec).Skip((PageNumber - 1) * PAGESIZE).Take(PAGESIZE).ToList(); foreach (var reg in tempList) Console.WriteLine(reg.PropertyName);