var PersonActive = (from Person in _dbContext.Person
join PersonWiseActionHistory in _dbContext.PersonWiseActionHistory on Person.Id Not equals PersonWiseActionHistory.PersonId
where Person.JobId == srchparam.ProjectId && Person.EffectFrom== ApplicationData.AppStringToDatetime(srchparam.SrchDate)
select new
{
PersonId = Person.Id,
PersonName = Person.Name,
Weightage = Person.Weightage
});