如何在wpf中将数据从一个sqlite数据库复制到另一个sqlite数据库？

SQLiteConnection sourceConnection = new SQLiteConnection("Data Source=source.db");
SQLiteConnection targetConnection = new SQLiteConnection("Data Source=target.db");

sourceConnection.Open();
targetConnection.Open();

SQLiteCommand command = new SQLiteCommand("SELECT * FROM TableName", sourceConnection);

SQLiteDataReader reader = command.ExecuteReader();

while (reader.Read())
{
    // 读取数据并组织插入语句
    string insertQuery = $"INSERT INTO TableName (Column1, Column2) VALUES ('{reader["Column1"]}', '{reader["Column2"]}')";
    
    // 创建一个新的SQLiteCommand对象，并执行插入语句
    SQLiteCommand insertCommand = new SQLiteCommand(insertQuery, targetConnection);
    insertCommand.ExecuteNonQuery();
}

reader.Close();
sourceConnection.Close();
targetConnection.Close();