Connect to OceanBase Database using OceanBase Connector/NET

wget https://dot.net/v1/dotnet-install.sh -O dotnet-install.sh
chmod +x dotnet-install.sh
./dotnet-install.sh --channel 10.0
echo 'export PATH="$HOME/.dotnet:$HOME/.dotnet/tools:$PATH"' >> ~/.bashrc
source ~/.bashrc

dotnet --version

mkdir dotnet-test
cd dotnet-test
dotnet new console
dotnet run

dotnet add <your project.csproj> package Oceanbase.ManagedDataAccess --version 1.0.0 --source "<package repository>" --source "https://api.nuget.org/v3/index.json"

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <packageSources>
    <add key="local-oceanbase" value="driver download directory" />
    <add key="nuget.org" value="https://api.nuget.org/v3/index.json" />
  </packageSources>
</configuration>

<ItemGroup>
  <PackageReference Include="Oceanbase.ManagedDataAccess" Version="1.0.0" />
</ItemGroup>

using Oceanbase;

namespace Program
{
    class Program
    {
        static void Main(string[] args)
        {
            OracleConnection conn = new OracleConnection("Server=xxxxx;Port=5858;Database=test;User Id=test@oracle;Password=test;");

            try
            {
                conn.Open();
                OracleCommand cmd = new OracleCommand("select to_char(sysdate, 'yyyy-MM-dd HH24:mi:ss') from dual ", conn);
                var reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    Console.WriteLine("sysdate is:" + reader.GetString(0));
                }

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }
    }
}

dotnet run

using Oceanbase;

var connectionString = "Server=host;Port=port;Database=schema_name;User Id=username@tenant_name#cluster_name;Password=password;";
using var conn = new OracleConnection(connectionString);
conn.Open();

using var cmd = conn.CreateCommand();
cmd.CommandText = "SELECT 1 FROM DUAL";
var result = cmd.ExecuteScalar();
Console.WriteLine($"Query result: {result}");

conn.Close();