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" %>
  3. <!DOCTYPE html>
  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;
  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. {
  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!