如何在一个连接中添加多个查询(从Visual Studio C#到PostgreSQL)

string connectionString = "Server=your_server_address;Port=your_port;Database=your_database;User Id=your_username;Password=your_password;";
NpgsqlConnection connection = new NpgsqlConnection(connectionString);

connection.Open();

NpgsqlCommand command = new NpgsqlCommand();
command.Connection = connection;
command.CommandText = "SELECT * FROM table1; SELECT * FROM table2;";

NpgsqlDataReader reader = command.ExecuteReader();

// 处理第一个查询结果
while (reader.Read())
{
    // 处理每一行数据
}

// 移动到下一个查询结果
reader.NextResult();

// 处理第二个查询结果
while (reader.Read())
{
    // 处理每一行数据
}

// 关闭DataReader
reader.Close();

connection.Close();