Similarities and differences between DeleteOnSubmit and DeleteAllOnSubmit

Little scum · Posted on 6/25/2015 10:38:09 AM

a. DeleteOnSubmit: Deletes an entity from the datacontext object and executes the changes when SubmitChange().

b. DeleteAllOnSubmit: Deletes a collection of entities from the datacontext object and executes the changes when SubmitChange().

Example:

protected void btnDelete_Click(object sender, EventArgs e)

{

      UsersDataContext dal = new UsersDataContext();

      User user = dal. Users.FirstOrDefault(s => s.UserName == "Tom");

      if (user != null)

      {

         dal. Users.DeleteOnSubmit(user); Delete individual pieces of data

      }

      var q = dal. Users;

      dal. Users.DeleteAllOnSubmit(q); Delete the dataset

      dal. SubmitChanges();

}

Note: The above two functions must follow the SubmitChange() function to delete data from the database. We can understand it in layman's terms: the above two functions are only equivalent to a Sql statement, and SubmitChange() is equivalent to executing this Sql statement.

[Source] Similarities and differences between DeleteOnSubmit and DeleteAllOnSubmit

Related Posts

Sections viewed