使用C#将大型CSV文件导入SQL Server

using System;
using System.Data.SqlClient;
using System.IO;

namespace CSVtoSQL
{
    class Program
    {
        static void Main(string[] args)
        {
            string csvFilePath = "path/to/csv/file.csv";
            string connectionString = "Data Source=your_server;Initial Catalog=your_database;User ID=your_username;Password=your_password";

            using (StreamReader reader = new StreamReader(csvFilePath))
            {
                using (SqlConnection connection = new SqlConnection(connectionString))
                {
                    connection.Open();

                    string line;
                    while ((line = reader.ReadLine()) != null)
                    {
                        string[] fields = line.Split(',');

                        // Assuming the CSV file has three columns: Column1, Column2, Column3
                        string column1 = fields[0];
                        string column2 = fields[1];
                        string column3 = fields[2];

                        string insertQuery = $"INSERT INTO YourTable (Column1, Column2, Column3) VALUES ('{column1}', '{column2}', '{column3}')";

                        using (SqlCommand command = new SqlCommand(insertQuery, connection))
                        {
                            command.ExecuteNonQuery();
                        }
                    }

                    connection.Close();
                }
            }

            Console.WriteLine("CSV data imported successfully to SQL Server.");
        }
    }
}