MVC

Add record to database

Create controller class and update following method

[AcceptVerbs(HttpVerbs.Post)]

public ActionResult Create([Bind(Exclude="Id")] Movie movieToCreate)

{
if (!ModelState.IsValid)
return View();
_db.AddToMovieSet(movieToCreate);
_db.SaveChanges();
return RedirectToAction("Index");


}

Two method of list of table content

ViewData.Model = _db.MovieSet.ToList();
ViewData.Model = (from m in _db.MovieSet select m).ToList();

Validate input data

if (String.IsNullOrEmpty(movieToAdd.Title))
ModelState.AddModelError("Title", "Title is required!");

Edit existing Record
var id = Int32.Parse(form["id"]);
var movieToUpdate = _db.MovieSet.First(m => m.Id == id);

// If valid, save movie to database
if (ModelState.IsValid)
{
_db.SaveChanges();
return RedirectToAction("Index");
}

// Otherwise, reshow form

return View(movieToUpdate);

Delete Existing record

// Get movie to delete
var movieToDelete = _db.MovieSet.First(m => m.Id == id);

// Delete
_db.DeleteObject(movieToDelete);
_db.SaveChanges();

// Show Index view
return RedirectToAction("Index");