This project has moved. For the latest updates, please go here.
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();

Last edited Nov 12, 2013 at 7:24 AM by scale_tone, version 1