This topic describes the complete process of using OceanBase Connector/NET, including environment preparation, project creation, driver installation, and connection verification.
Note
The examples in this topic are based on a Linux environment and an Oracle tenant. If you use Windows or MySQL mode, you can follow the same steps to complete the installation and connection.
Environment preparation
- An accessible OceanBase Database instance.
- Database account, password, host address, and port information.
- .NET SDK installed (Linux/macOS command examples are provided).
Notice
Before installing .NET 10.0 on Linux, make sure that your system meets the glibc version requirements.
Procedure
Step 1: Install the .NET runtime environment
For Windows, you can download the installation package from the Microsoft official website. For Linux/macOS, run the following command:
Note
This topic uses .NET 10.0 as an example. In practice, you can choose other supported .NET versions based on project compatibility requirements. The installation steps are the same.
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
Verify the installation result:
dotnet --version
If the output is 10.0.0 or a higher version, the installation is successful.
Step 2: Create a console project
mkdir dotnet-test
cd dotnet-test
dotnet new console
dotnet run
If the console output is Hello, World!, the project is created successfully.
Step 3: Install OceanBase Connector/NET
After downloading the driver to your local machine, run the following command in the project directory to install the driver:
dotnet add <your project.csproj> package Oceanbase.ManagedDataAccess --version 1.0.0 --source "<package repository>" --source "https://api.nuget.org/v3/index.json"
Note
If you use the official NuGet package source, retain --source "https://api.nuget.org/v3/index.json".
You can also modify the nuget.config file, for example:
<?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>
After the installation is successful, you can see the following configuration in the .csproj file:
<ItemGroup>
<PackageReference Include="Oceanbase.ManagedDataAccess" Version="1.0.0" />
</ItemGroup>
Step 4: Write a connection sample code
Modify the Program.cs file as follows:
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();
}
}
}
}
Step 5: Run the connection verification
dotnet run
If the current time is output, the connection and query are successful.