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 });