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

Anupam Mishra 1829 05 Feb 2016

Hello Everyone,

I want to know how to sort record with the using of entity framework in ASP.NET MVC. Can anyone give me a solution with example.

Thank you.

1 Answers

Anupam Mishra 05 Feb 2016

Finally, I have solve this problem.

For solution of above problem, we are creating one student controller and its index view. We want to display 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 => s.FirstName);
         break;
      case "Date":
         students = students.OrderBy(s => s.EnrollmentDate);
         break;
      case "Date_desc":
         students = students.OrderByDescending(s => s.EnrollmentDate);
         break;
      default:
         students = students.OrderBy(s => s.FirstName);
         break;
   }
   return View(students.ToList());
}

In Views\Student\Index.cshtml, We have changed below lines:

<p>
    @Html.ActionLink("Create New Student Record", "Create")
</p>
<table>
    <tr>
        <th>
            @Html.ActionLink("First Name", "Index", new { sortOrder = ViewBag.NameSortParm })
        </th>
        <th> Last Name
        </th>
        <th>
            @Html.ActionLink("Enrollment Date", "Index", new { sortOrder = ViewBag.DateSortParm })
        </th>
        <th></th>
    </tr>

    @foreach (var item in Model)
    {

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

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

Can you answer this question?

1 Answers