将行批量插入sql server的最快方法

CREATE TYPE dbo.MyTableType AS TABLE (
    Column1 INT,
    Column2 VARCHAR(50),
    Column3 DATETIME
)

CREATE PROCEDURE dbo.BulkInsertData
    @MyTableVariable dbo.MyTableType READONLY
AS
BEGIN
    INSERT INTO MyTable (Column1, Column2, Column3)
    SELECT Column1, Column2, Column3 FROM @MyTableVariable
END

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

    DataTable dataTable = new DataTable();
    dataTable.Columns.Add("Column1", typeof(int));
    dataTable.Columns.Add("Column2", typeof(string));
    dataTable.Columns.Add("Column3", typeof(DateTime));

    // Add rows to the dataTable

    using (SqlCommand command = new SqlCommand("dbo.BulkInsertData", connection))
    {
        command.CommandType = CommandType.StoredProcedure;
        SqlParameter parameter = command.Parameters.AddWithValue("@MyTableVariable", dataTable);
        parameter.SqlDbType = SqlDbType.Structured;
        parameter.TypeName = "dbo.MyTableType";

        command.ExecuteNonQuery();
    }
}