Linq - Using String.StartsWith

var query = from h in dbk.Employee_table
            where h.City.StartsWith("L") && h.City.Contains("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 starts with a Capital 'L', than some character, than 'n' and than the rest of the name.

Equivalent sql statement will be :-

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

Thanks and Regards
Akiii