SQL Bulk Copy (C#)

using System;

using System.Data;

using System.Data.SqlClient;

class Program

{

    static void Main()

    {

        string connectionString = "your_connection_string_here";

        using (SqlConnection conn = new SqlConnection(connectionString))

        {

            conn.Open();

            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn))

            {

                bulkCopy.DestinationTableName = "Employees";

                DataTable employeeTable = new DataTable();

                employeeTable.Columns.Add("Id", typeof(int));

                employeeTable.Columns.Add("Name", typeof(string));

                employeeTable.Columns.Add("Age", typeof(int));

                employeeTable.Rows.Add(1, "Alice", 25);

                employeeTable.Rows.Add(2, "Bob", 30);

                bulkCopy.WriteToServer(employeeTable);

            }

        }

        Console.WriteLine("Bulk insert completed!");

    }

}