How to sorting with the entity framework is an ASP.NET MVC Application

Question

Anupam Mishra · Answer

Finally, I have solve this problem.For solution of above problem, we are creatingand one student controller and its index view. We want to display and a sort records(i.e. First Name,Last Name or Enrollment date) in index view.this is a code of Student Controller Index Action:public ActionResult Index(string sortOrder)
{
 ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name" : "";
 ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date";
 var students = from s in db.Student // Student is a table i.e. containing records of student
 select s;
 switch (sortOrder)
 {
 case "Name":
 students = students.OrderByDescending(s =andgt; s.FirstName);
 break;
 case "Date":
 students = students.OrderBy(s =andgt; s.EnrollmentDate);
 break;
 case "Date_desc":
 students = students.OrderByDescending(s =andgt; s.EnrollmentDate);
 break;
 default:
 students = students.OrderBy(s =andgt; s.FirstName);
 break;
 }
 return View(students.ToList());
}Inand Views\Student\Index.cshtml, We have changed below lines:andlt;pandgt;
 @Html.ActionLink("Create New Student Record", "Create")
andlt;/pandgt;
andlt;tableandgt;
 andlt;trandgt;
 andlt;thandgt;
 @Html.ActionLink("First Name", "Index", new { sortOrder = ViewBag.NameSortParm })
 andlt;/thandgt;
 andlt;thandgt; Last Name
 andlt;/thandgt;
 andlt;thandgt;
 @Html.ActionLink("Enrollment Date", "Index", new { sortOrder = ViewBag.DateSortParm })
 andlt;/thandgt;
 andlt;thandgt;andlt;/thandgt;
 andlt;/trandgt;
 @foreach (var item in Model)
 {

forum

How to sorting with the entity framework is an ASP.NET MVC Application

Anupam Mishra

1 Answers

Liked By