public void Update(CardViewModel card) { try { using (var context = new CardHolderContext()) { var updateCard = context.Cards.Where(x => x.CardId == card.CardDetails.CardId).FirstOrDefault(); updateCard.CompanyName = card.CardDetails.CompanyName; updateCard.CategoryId = card.CardDetails.CategoryId; updateCard.JobTitle = card.CardDetails.JobTitle; updateCard.OwnerName = card.CardDetails.OwnerName; updateCard.Tagline = card.CardDetails.JobTitle; updateCard.Website = card.CardDetails.Website; context.SaveChanges(); var updateContact = context.ContactDetails.Where(x => x.CardId == card.CardDetails.CardId).FirstOrDefault(); updateContact.City = card.Contact.City ; updateContact.Country = card.Contact.Country; updateContact.Email = card.Contact.Email; updateContact.FixNumber = card.Contact.FixNumber; updateContact.MobileNumber = card.Contact.MobileNumber; updateContact.Street = card.Contact.Street; context.SaveChanges(); var deleteSocial = context.SocialMedia.Where(x => x.CardId == card.CardDetails.CardId).ToList(); context.SocialMedia.RemoveRange(deleteSocial); context.SaveChanges(); if (card.SocialMedia.Count > 0) { foreach (var item in card.SocialMedia) { item.CardId = card.CardDetails.CardId; item.SocialId = 0; context.SocialMedia.Add(item); } } context.SaveChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } }