In this tutorial, we are going to build a simple AJAX Pagination with search and sort using Entity Framework with ASP.NET MVC. This tutorial assumes that you already have an existing ASP.NET MVC web application built using Visual Studio 2013 or 2015. What you see in the above picture is exactly what we are going to build out. So let’s get started.

In Visual Studio, create a new Model class under your Models folder and name it ProductModel.cs. In it add the following code:

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace MyAppName.Models
{
    public class Product
    {
        public int id { get; set; }
        public string name { get; set; }
        [AllowHtml]
        public string content { get; set; }
        public string excerpt { get; set; }
        public DateTime? date { get; set; }
        public decimal price { get; set; }
        public int quantity { get; set; }
        public int status { get; set; }
        public int author { get; set; }
        public string images { get; set; }
        public string featured_image { get; set; }
    }

    public class ProductDBContext : DbContext
    {
        public DbSet<Product> Products { get; set; }
    }
}

From the Solution Explorer of Visual Studio, right click on the Models Folder -> Add -> New Scaffolded Item

A new window will pop-up, select MVC 5 Controller with views, using Entity Framework then click Add.

On the next window: Under Model class select Product(MyAppName.Models), for the Data context class select ProductDBContext (MyAppName.Models). If you have an existing razor layout, you can use it as the new view for our Products scaffold. Click the Add button when you’re done. This will start generating the necessary views and controller for our Products.

We can now start working on the pagination.

Navigate to View -> Products -> Index.cshtml then replace the Index() method with the following….

Click here to download the FULL TUTORIAL

 

 

---