OceanBase Connector/NET is a driver developed in C# and running on the .NET platform. It provides applications with connectivity to OceanBase Database and supports the following modes:
- Oracle-compatible mode: Supports Oracle-compatible APIs (such as
OracleConnection,OracleCommand, andOracleDataReader). - MySQL-compatible mode: Uses the same method as MySqlConnector, with the same connection approach.
Cross-platform support
OceanBase Connector/NET is cross-platform and can run on Windows, Linux, and macOS. It enables enterprise applications to uniformly access OceanBase Database across various deployment environments.
Main modules and support status
This topic focuses on the features in Oracle-compatible mode. MySQL-compatible mode uses the same method as MySqlConnector and is not covered here.
Module |
Supported operations |
|---|---|
| OracleTransaction | Commit (Commit/CommitAsync) and rollback (Rollback/RollbackAsync); named savepoints; isolation levels ReadCommitted, RepeatableRead, and Serializable (ReadUncommitted and Snapshot are not supported). |
| OracleCommand | CommandType.Text, CommandType.StoredProcedure; ExecuteNonQuery, ExecuteScalar, ExecuteReader (including asynchronous); Prepare/PrepareAsync; OUT/InputOutput/ReturnValue parameters of stored procedures; REF CURSOR result sets; ArrayBinding for batch DML (requiresUseArrayBinding=true、ArrayBindCountandAutoCommit=false);CommandTimeout、Cancel;LastInsertedId. |
| OracleDataReader | Read/ReadAsync, NextResult/NextResultAsync; GetValue, GetString, GetInt16/32/64, etc.; GetOracleBlob, GetOracleClob, GetOracleTimeStamp, and other Oracle types; multi-result set and REF CURSOR traversal; RowId reading. |
| OracleDataAdapter | You can use the SelectCommand to query data and populate a DataSet or DataTable. You can also configure InsertCommand, UpdateCommand, and DeleteCommand for data updates. |
| OracleConnection | Open/OpenAsync, Close/CloseAsync; BeginTransaction, CreateCommand, ChangeDatabase, Ping; connection pool, SSL; EnlistTransaction (distributed transaction). In Oracle-compatible mode, a database (schema) must be specified. Current limitations: GetSchema is not supported; CreateBatch (batch processing) is not supported. |
| OracleParameter | Named parameters (@name, :name); Direction: Input, Output, InputOutput,ReturnValue; OracleDbType and DbType; UDT (OracleDbType.Object / OracleDbType.Array) andUdtTypeName. |
| UDT | OBJECT / VARRAY custom type mapping (IOracleCustomType/ Factory) and NULL Sentinel (IOracleNullable)、DeriveParametersMetadata derivation. |
| OracleDataSource | ViaOracleDataSourceorOracleClientFactory.CreateDataSource()Create a data source and obtain a connection. |
| OracleCommandBuilder | SupportedDeriveParametersStatic methods automatically derive parameter information from the stored procedure. |
| OracleClientFactory | ImplementationDbProviderFactory, you can createOracleConnection、OracleCommand、OracleCommandBuilder、OracleDataAdapter、OracleDataSourceand other objects. |
Unsupported scenarios
- GetSchema (Calling this method on an OracleConnection object throws a NotSupportedException.)
- CreateBatch (Batch processing)