Like operator or using wildcards in LINQ to Entities
Entity Model Name : TestLinqDataContext db = new TestLinqDataContext(); var obj = from p in db.TagMasters where SqlMethods.Like(p.TagCode, "%" + TextBox2.Text + "%") select new { p.TagCode,p.Status,p.ExpirationDate };