从一个表到另一个表的C# sql插入计数

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string sourceConnectionString = "Data Source=(local);Initial Catalog=SourceDB;Integrated Security=True";
        string destinationConnectionString = "Data Source=(local);Initial Catalog=DestinationDB;Integrated Security=True";

        string selectQuery = "SELECT * FROM SourceTable";
        string insertQuery = "INSERT INTO DestinationTable (Column1, Column2) VALUES (@Value1, @Value2)";

        int count = 0;

        using (SqlConnection sourceConnection = new SqlConnection(sourceConnectionString))
        {
            using (SqlConnection destinationConnection = new SqlConnection(destinationConnectionString))
            {
                SqlCommand selectCommand = new SqlCommand(selectQuery, sourceConnection);
                SqlCommand insertCommand = new SqlCommand(insertQuery, destinationConnection);

                try
                {
                    sourceConnection.Open();
                    destinationConnection.Open();

                    SqlDataReader reader = selectCommand.ExecuteReader();

                    while (reader.Read())
                    {
                        insertCommand.Parameters.Clear();
                        insertCommand.Parameters.AddWithValue("@Value1", reader["Column1"]);
                        insertCommand.Parameters.AddWithValue("@Value2", reader["Column2"]);

                        insertCommand.ExecuteNonQuery();
                        count++;
                    }

                    reader.Close();
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error: " + ex.Message);
                }
            }
        }

        Console.WriteLine("Total records inserted: " + count);
        Console.ReadLine();
    }
}