/// <summary> /// Method to delete a single item from the database /// </summary> /// <param name="id">id of the item marked for deletion</param> /// <returns></returns> public ActionResult Delete(int id) { var dbContext = new TransactionsContext(); var itemToRemove = dbContext.testts.SingleOrDefault(x => x.Id == id); if (itemToRemove != null) { dbContext.testts.Remove(itemToRemove); dbContext.SaveChanges(); } return(RedirectToAction("ViewDbData")); }
public void SalvarTransacoes(List <Transaction> trs) { foreach (var item in trs) { using (var ctx = new TransactionsContext()) { using (var ctxTransaction = ctx.Database.BeginTransaction()) { try { ctx.Entry(item.Account).State = EntityState.Modified; ctx.Transactions.Add(item); ctx.SaveChanges(); ctxTransaction.Commit(); } catch (Exception) { ctxTransaction.Rollback(); } } } } }