Searching a database column

Question

User-808702305 posted

return View(db.AllTitles.Where(x => x.BookName.StartsWith(search) || search == null).ToList());

Here I used "StartsWith" function but this is not much efficient. It only gets the results which starts with the typed letters. Is there any function I can use here that searches and gives me the results of matching words for a search?

Answer 1

User2103319870 posted

Here I used "StartsWith" function but this is not much efficient. It only gets the results which starts with the typed letters. Is there any function I can use here that searches and gives me the results of matching words for a search?

You can use Contains in linq like below

return View(db.AllTitles.Where(x => x.BookName.Contains(search) || search == null).ToList());

Answer 2

User-707554951 posted

Hi Zeeshan Cheema

public ViewResult Index(string searchString)
{
  
    var students = from s in db.Students
                   select s;
    if (!String.IsNullOrEmpty(searchString))
    {
        students = students.Where(s => s.LastName.Contains(searchString));
    }
  
    return View(students.ToList());
}

Refer to: https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/sorting-filtering-and-paging-with-the-entity-framework-in-an-asp-net-mvc-application

Or you could create search function in database if you database first as below:

https://www.aspsnippets.com/Articles/Implement-Search-functionality-in-ASPNet-MVC.aspx

If you use code first approach, you could  learn how to generate SP  by referring to the link below:

https://www.mikesdotnetting.com/article/299/entity-framework-code-first-and-stored-procedure

https://msdn.microsoft.com/en-gb/data/dn468673.aspx

Best regards

Cathy