public static void UpdateStockCompany(StockCompany updStockComp) { using (var db = new InvestmentEntities()) { var stockCmp = db.StockCompanies.FirstOrDefault(x => x.TickerCode == updStockComp.TickerCode); if (stockCmp == null) { return; } if (updStockComp.LatsUpdatedOn != null) { stockCmp.LatsUpdatedOn = updStockComp.LatsUpdatedOn; } db.Entry <StockCompany>(stockCmp).State = EntityState.Modified; db.SaveChanges(); } }