public IActionResult Committees() { APIHandler webHandler = new APIHandler(); Committees committees = webHandler.GetCommittees(); foreach (var item in committees.results) { if (dbContext.Committees.Where(c => c.committee_id.Equals(item.committee_id)).Count() == 0) { dbContext.Committees.Add(item); } } dbContext.SaveChanges(); foreach (var item in committees.results) { Committee can = dbContext.Committees.First(a => a.committee_id == item.committee_id); string candi = string.Join(",", item.candidate_ids); can.candidate_id = candi; } dbContext.SaveChanges(); return(View(committees)); }