Using .contains LINQ method doesn't work properly.

Question

Hello

I'm trying to convert SQL like command to LINQ

select EmployeeID,EnName from EmployeeMaintenance
where EmployeeID like '1'

in c# code i replace the 1 with variable, that will be any value, but in debug i provide the same value which is 1:

var test= _context.EmployeeMaintenances
.Where(c => c.EmployeeID.Contains(param.sSearch));

But the result is the wohle list in the table EmployeeMaintenances !!?

can any one figure the problem?

Rehman Shahid · Answer

For this Query select EmployeeIDEnName from EmployeeMaintenance where EmployeeID like '1' The LINQ should syntax should be var test= _context.EmployeeMaintenances . Where (c => c.EmployeeID.Equals(param.sSearch)); And For This SQL Query select EmployeeIDEnName from EmployeeMaintenance where EmployeeID like '%1%' LINQ syntax should be var test= _context.EmployeeMaintenances . Where (c => c.EmployeeID. Contains (param.sSearch));