Delete

To DELETE the object we can use db.Delete or db.DeleteAll functions

Delete - deletes an object that was retrieved from the database.

DeleteAll - deletes the object and its dependent objects are involved

Example of delete:

IEnumerable listOfMovies = db.ExecuteQuery("SELECT Movie WHERE Genre >= 5");

foreach (Movie mov in listOfMovies)

{

// Delete - deletes an object that was retrieved from the database.

db.Delete(mov);

}