How can i perform an LIKE query within Linq?
I have the following query i would like to execute.
var results = from c in db.costumers
where c.FullName LIKE "%"+FirstName+"%,"+LastName
select c;
How to do a LIKE query with linq?
Viewed 130927
8 Answers
2019 is here:
Requires EF6
using System.Data.Entity;
string searchStr ="bla bla bla";
var result = _dbContext.SomeTable.Where(x=> DbFunctions.Like(x.NameAr, string.Format("%{0}%", searchStr ))).FirstOrDefault();
Related