Implement Search functionality without using Stored Procedure in ASP.Net MVC

Hi Ainguahj,

If you don't want to use stored procedure then use Link query with where condition to filter the record.

C#

[HttpPost]
public ActionResult Index(string customerName)
{
    NorthwindEntities entities = new NorthwindEntities();
    return View(entities.Customer.Select(s => new { s.CustomerID, s.ContactName, s.City, s.Country }).Where(s => s.ContactName.StartsWith(customerName)).ToList());
}