LINQ - EndsWith

Posted by Akiii under LINQ category on | Points: 40 | Views : 3778
var query = from h in dbk.Employee_table
where h.City.EndsWith("n")
select h;

dbk = It is the DataContext object (With the help of this object, we can get access to any table in the respective database)

The above query will search employee table city column which ends with 'n'.

Equivalent sql statement will be :-

SELECT Emp_ID, City, ...
FROM dbo.Employee_table
WHERE City LIKE [%n]

Thanks and Regards

Comments or Responses

Login to post response