Performing LIKE '%query%' Searches in LINQ
When searching and the need arises for LIKE '%query%' using Linq to SQL, use below:
[Route("search")]
[HttpPost]
public IActionResult Search(string search)
{
var posts = _db.Posts
.Where(x => x.Body.Contains(search))
.Where(x => x.Title.Contains(search)).ToArray();
ViewBag.SearchCriteria = search;
ViewBag.TagView = new TagView(_db);
return View(posts);
}
Older/Redacted code
using System.Data.Linq.SqlClient;
result = (from b in db.Blogs
where SqlMethods.Like(b.Title, "%" + keyword + "%") ||
SqlMethods.Like(b.Body, "%" + keyword + "%")
orderby b.AddedDate descending
select b);