LINQ to SQL LIKE Operator
LINQ to SQL LIKE Operator By using Contains(), StartsWith(), EndsWith() we can implement LIKE operator in LINQ to SQL. like '%SearchString%' = Contains("SearchString") like '%SearchString' = StartsWith("SearchString") like 'SearchString%' = EndsWith("SearchString") Input tables Employees table LINQ Query Contains(): MyDBDataContext sqlObj = new MyDBDataContext (); var employees = from emps in sqlObj.tblEmployees where emps.EmployeeName.Contains( "en" ) select new { emps.EmployeeID, ...