How do I add filter to my table using entity framework and razor engine?

See more:

MVC

Razor

MVC5

EF6.0

Hi,

I have an MVC5 application that gets data from my SQL Server table and outputs it on cshtml using Razor engine. I just used the auto-generated code that visual studio 2013 created when I added a new item. I want to add a link that creates a filter and sorting of the table. I'm not sure how to do that with Razor.

Here is my controller:

private AH_ODS_DB_Entities db = new AH_ODS_DB_Entities();

// GET: /Home/
public ActionResult Index()
{
    return View(db.Transmitals.ToList());
}

Any recommendations for a book about MVC5, entityframework or Razor engine?