https://dotnetgenetics.blogspot.com/2013/03/iorderedqueryable-extension-method-c.html

Extension method on IQueryable class

  public static class IQueryableExtensions

    {

        public static IQueryable<TSource> GetPagedData<TSource>(this IQueryable<TSource> query, int pageNumber, int pageSize)

        {

            return query.Skip((pageNumber - 1) * pageSize).Take(pageSize);

        }

    }

To Use

   var query = _appDbContext.<dbSetName>.

                .OrderBy(p => p.<col_name>).GetPagedData(pageNumber, pageSize);