from ContentDetails in _dbContext.ContentDetails join VersionDetails in _dbContext.VersionDetails on ContentDetails.Id equals VersionDetails.ContentId join MstStage in _dbContext.MstStage on ContentDetails.Status equals MstStage.Id where ContentDetails.FacultyName=like search here select new { VersionDetails.ContentId, ContentDetails.Id, ContentDetails.DeptId, ContentDetails.DeptName, ContentDetails.CourseId, ContentDetails.CourseName, ContentDetails.Semester, ContentDetails.PaperId, ContentDetails.PaperName, ContentDetails.ContentTypeId, ContentDetails.ContenType, ContentDetails.FacultyId, ContentDetails.FacultyName, ContentDetails.Topic, ContentDetails.LanguageId, ContentDetails.LanguageName, MstStage.Mode, VersionDetails.VersionId, VersionDetails.VersionName, VersionDetails.VersionNote, ContentDetails.CreatedBy, ContentDetails.CreatedOn, ContentDetails.ModifiedBy, ContentDetails.ModifiedOn };