Skip to content

Creating, Removing and Updating entities

scale-tone edited this page Apr 16, 2017 · 2 revisions
var newMovie = new Movie
{
    Genre = "Melodrama",
    Title = "Groundhog Day",
    Year = 1993,
    Director = "Harold Ramis"
};
moviesTable.InsertOnSubmit(newMovie);
ctx.SubmitChanges();

var movieToModify = moviesTable.Where(m => m.Title == "Terminator 123").Single();
movieToModify.Year = 2113;
ctx.SubmitChanges();

var movieToRemove = moviesTable
    .Where(m => m.Title == "The men who stare at the goats")
    .Single();
moviesTable.RemoveOnSubmit(movieToRemove);
ctx.SubmitChanges();