This is one those queries that just makes me want to shake my head; as you are searching for COLUMN_NAME which you already know.
The 2 choices for the result of this query are either going to be
NULL or the name of the column name you are searching for
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'EmpDatas'
AND COLUMN_NAME = N'JobTitle'
It just does not make sense to me when compare to the C# call which looks like a search of the
EmpData
table for an employee who has a job title containing the text contained in
parameter.
var search = db.EmpDatas.Where(p => p.JobTitle.Contains(parameter));
What I would think think you actually want for a query is
SELECT *
FROM EmpDatas
WHERE JobTitle LIKE '%parameter%'