Ex:join master table with emp table and fetch empname from master table based on Id present in emp table and search if it contains specific string passed as parameter in master or search I'd passed in emp table.. It basically autocomplete search where u can search based on Id and also name

I want equivalent linq for below sql qwery

```
select app.employeeid, emp.employeename
from applicant app
join [EmployeeMaster] emp on app.employeeid = emp.EmployeeId
where app.employeeid like '%empid%' or emp.EmployeeName like '%empname%' 

```

Can someone please help.