Asp.Net uses Bulk for bulk insertion of data

This article describes the example of Asp.Net using Bulk to achieve the method of batch insert data, to share with you for your reference. The specific methods are as follows:

The main functional codes are as follows:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Diagnostics;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Fx678Member.Framework.Exceptions;
 
namespace MeiYuanJinYe.Admin.HttpHandler
{
  /// <summary>
  /// CreateAccount  Summary of the 
  /// </summary>
  public class CreateAccount : IHttpHandler
  {
 
    public void ProcessRequest(HttpContext context)
    {
      context.Response.ContentType = "text/plain";
      Guid classRoomId = Guid.Parse(context.Request["ClassRoomId"]);
      int Count = int.Parse(context.Request["Count"]);
      DataTable dt = GetTableSchema();
      Random ran = new Random();
      for (int i = 0; i < Count; i++)// Loop to DataTable In the assignment 
      {
        DataRow r = dt.NewRow();
        r[1] = ran.Next(10000000, 100000000);
        r[2] = ran.Next(10000000, 100000000);
        r[3] = classRoomId;
        r[4] = DateTime.Now;
        r[5] = 1;
        dt.Rows.Add(r);
      }
      BulkToDB(dt);
      context.Response.Write(BulkToDB(dt) ? "ok" : "error");
      context.Session["dataTable"] = dt;
    }
 
    public void BulkToDB(DataTable dt)
    {
      SqlConnection sqlConn = new SqlConnection(ConfigurationManager.AppSettings["ConnString"]);
      SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConn);
      bulkCopy.DestinationTableName = "ClassRoomAccount";// Database table name 
      bulkCopy.BatchSize = dt.Rows.Count;
      try
      {
        sqlConn.Open();
        if (dt != null && dt.Rows.Count != 0)
          bulkCopy.WriteToServer(dt);
      }
      catch (Exception ex)
      {
        new AppException(" Batch generation studio account abnormal ", ex);
      }
      finally
      {
        sqlConn.Close();
        if (bulkCopy != null)
          bulkCopy.Close();
      }
    }
 
    public DataTable GetTableSchema()
    {
      DataTable dt = new DataTable();
      dt.Columns.AddRange(new DataColumn[]{ 
        new DataColumn("AccountId",typeof(int)), 
        new DataColumn("AccountName",typeof(string)), 
        new DataColumn("Password",typeof(string)),
        new DataColumn("ClassRoomId",typeof(Guid)),
        new DataColumn("AddDate",typeof(DateTime)),
        new DataColumn("IsActive",typeof(int))
      });// Database table structure 
      return dt;
    }
    public bool IsReusable
    {
      get
      {
        return false;
      }
    }
  }
}

I hope this article is helpful to your asp.net program design.