\[code\] const string keyword = "manoj"; rsp.DataSource = company.GetCompanySearch(keyword); rsp.DataBind(); using (var context = huntableEntities.GetEntitiesWithNoLock()) { IEnumerable<Company> query = context.Companies.ToList(); if (!string.IsNullOrEmpty(keyword)) { keyword = keyword.ToLower(); query = query.Where(u=>u.CompanyName.Contains(keyword) || u.EmailAdress.Contains(keyword) ||u.MasterCountry.Description.Contains(keyword) ||u.MasterIndustry.Description.Contains(keyword) ||u.CompanyDescription.Contains(keyword) ||u.CompanyHeading.Contains(keyword)); } return query.ToList(); }\[/code\]Query not getting the results. The database has 27 records with name manoj. The inner exception is null for this