Post
Ask Question

InsertAllOnSubmit Method in LINQ to SQL

Introduction

In this article we will see how to add data to database using linqtosql with insertallonsubmit method.

Step 1: Create asp.net web application

WebForm1.aspx

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="InsertAllOnSubmit_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="Insert 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 InsertAllOnSubmit_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.         protected void Button1_Click(object sender, EventArgs e)  
  18.         {  
  19.             List<Employee> emp = new List<Employee>(){  
  20.                 new Employee{FirstName = "Andy", LastName="Jones"},  
  21.                 new Employee{FirstName = "Steve", LastName="Robes"},  
  22.                 new Employee{FirstName = "David", LastName="Orme"},  
  23.             };  
  24.             objContext.Employees.InsertAllOnSubmit(emp);  
  25.             objContext.SubmitChanges();  
  26.         }  
  27.     }  
  28. }  

Output of the application looks like this

 

Summary

In this blog we have seen how we can add data to database using linqtosql with insertallonsubmit. Happy coding!
Next Recommended Reading Resolve LINQ to Entities Does Not Recognize the Method ToString Exception

MVC Corporation
MVC Corporation is consulting and IT services based company.