When i join two tables using LINQ then it working properly but when i join two tables and i use the Where Clause then the LINQ query does not display any record. Following is my complete Action Method in which i joined two tables one is EmployeeGeneralDetails table and another one is PassportDetails table. Its working without the Where Clause but when i want to display a single record using the Employee ID and i used the Where condition then its not working. Please check my Where clause why its not working. Following is the Action Method:
public IActionResult SearchEmployeePassportInfoByID(string id)
{
var empPassportInfo = from p in dbContext.PassportDetails
join emp in dbContext.EmployeeGeneralDetails on p.EmpCode equals emp.EmpCode
where emp.EmpCode == id
select new RetrieveEmployeePassportDetails
{
EmpCode = p.EmpCode,
EmpFullName = emp.EmpFullName,
IssuingCountry = p.IssuingCountry,
IssueDate = p.IssueDate,
ExpiryDate = p.ExpiryDate
};
return PartialView(empPassportInfo);
}