保持c#中的oracle连接处于活动状态

using Oracle.ManagedDataAccess.Client;

public class OracleConnectionManager
{
    private OracleConnection connection;

    public OracleConnectionManager(string connectionString)
    {
        connection = new OracleConnection(connectionString);
    }

    public void OpenConnection()
    {
        try
        {
            connection.Open();
            Console.WriteLine("Oracle connection opened successfully.");
        }
        catch (OracleException ex)
        {
            Console.WriteLine("Error while opening Oracle connection: " + ex.Message);
        }
    }

    public void CloseConnection()
    {
        try
        {
            connection.Close();
            Console.WriteLine("Oracle connection closed successfully.");
        }
        catch (OracleException ex)
        {
            Console.WriteLine("Error while closing Oracle connection: " + ex.Message);
        }
    }
}

// 使用示例
string connectionString = "Data Source=your_oracle_server;User Id=your_username;Password=your_password;Pooling=true;";
OracleConnectionManager connectionManager = new OracleConnectionManager(connectionString);
connectionManager.OpenConnection();

// 执行数据库操作

connectionManager.CloseConnection();