pagination in C# skip and take using entity framwork

 int skip = (pageNumber - 1) * pageSize;

            searchText = searchText.ToUpper();
            var data = DbContext.BINRegisters.Where(m => m.BINNo.ToUpper().Contains(searchText)
                || m.BINType.ToUpper().Contains(searchText)
                ).Skip(skip).Take(pageSize).ToList();

            return data;

Comments

Popular posts from this blog

How to use DbFunctions.TruncateTime

Provision AWS EC2 Instance and RDS with Terraform, and Deploy Spring Boot App to EC2 Instance via GitHub Action Pipeline

Microsoft Access Connectivity from C#