在C#中向SQL Server插入动态行数的最佳方法是什么

string connectionString = "YourConnectionString";
string insertQuery = "INSERT INTO YourTable (Column1, Column2) VALUES (@Value1, @Value2)";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    
    using (SqlCommand command = new SqlCommand(insertQuery, connection))
    {
        // 添加参数并设置值
        command.Parameters.AddWithValue("@Value1", value1);
        command.Parameters.AddWithValue("@Value2", value2);
        
        // 执行查询
        command.ExecuteNonQuery();
    }
}

string connectionString = "YourConnectionString";
string tableName = "YourTable";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    
    using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
    {
        bulkCopy.DestinationTableName = tableName;
        
        // 创建一个 DataTable 并添加数据行
        DataTable dataTable = new DataTable();
        dataTable.Columns.Add("Column1", typeof(int));
        dataTable.Columns.Add("Column2", typeof(string));
        
        // 添加多行数据
        dataTable.Rows.Add(value1, value2);
        dataTable.Rows.Add(value3, value4);
        // ...
        
        // 执行批量插入
        bulkCopy.WriteToServer(dataTable);
    }
}