DeleteAllOnSubmit Method in LINQ to SQL

Introduction

In this article we will see how to delete data from database using linqtosql with deleteallonsubmit method.

Step 1: Create ASP.NET Web Application

 

WebForm1.aspx

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="DeleteAllOnSubmit_LINQtoSQL.WebForm1" %>  
  2.   
  3. <!DOCTYPE html>  
  4.   
  5. <html xmlns="http://www.w3.org/1999/xhtml">  
  6. <head runat="server">  
  7.     <title></title>  
  8. </head>  
  9. <body>  
  10.     <form id="form1" runat="server">  
  11.     <div>  
  12.         <asp:Button ID="Button1" runat="server" Text="Delete Data" OnClick="Button1_Click" />  
  13.     </div>  
  14.     </form>  
  15. </body>  
  16. </html>  

WebForm1.aspx.cs

  1. using System;  
  2. using System.Collections.Generic;  
  3. using System.Linq;  
  4. using System.Web;  
  5. using System.Web.UI;  
  6. using System.Web.UI.WebControls;  
  7.   
  8. namespace DeleteAllOnSubmit_LINQtoSQL  
  9. {  
  10.     public partial class WebForm1 : System.Web.UI.Page  
  11.     {  
  12.         DataClasses1DataContext objContext = new DataClasses1DataContext();  
  13.         protected void Page_Load(object sender, EventArgs e)  
  14.         {  
  15.   
  16.         }  
  17.   
  18.         protected void Button1_Click(object sender, EventArgs e)  
  19.         {  
  20.             List<Employee> emp = new List<Employee>()   
  21.             { new Employee { EmpId = 1 },   
  22.               new Employee { EmpId = 2 },   
  23.               new Employee { EmpId = 3 }   
  24.             };  
  25.   
  26.             objContext.Employees.DeleteAllOnSubmit(emp);  
  27.             objContext.SubmitChanges();  
  28.               
  29.         }  
  30.     }  
  31. }  

Output of the application looks like this

Summary

In this blog we have seen how we can delete data from database using linqtosql with deleteallonsubmit. Happy coding!