public ActionResult Edit(MyTableModel item) { try { string query = "UPDATE MyTable SET Name = @Name , Value= @Value WHere Id = @Id"; _db.Execute(query, item); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(MyTableModel item) { try { string query = "INSERT INTO MyTable VALUES(@Name,@Value)"; _db.Execute(query, item); return(RedirectToAction("Index")); } catch { return(View()); } }