This topic describes the commonly used ADO.NET interfaces and their support status in OceanBase Connector/NET.
Note
This page provides an overview of the interface capabilities. For more information about the connection string and parameters, see Connection string.
Main interfaces
Interface |
Support status |
|---|---|
| OracleConnection | Supported. The connection parameters are compatible with those of MySqlConnector. |
| OracleCommand | Supported. It supports the ExecuteNonQueryAsync, ExecuteScalarAsync methods, result sets, the PS protocol, ArrayBinding, and stored procedure calls. |
| OracleDataReader | Supported. It supports basic reading and the numeric, character, time, BLOB/CLOB/RAW data types, RowId reading, and reading of result sets returned by stored procedures. |
| OracleTransaction | Supported. It supports basic transaction operations and isolation levels. |
| OracleParameter | Supported. It supports input parameters when the CommandType is set to Text. It also supports output, input/output, and returnvalue (including refcursor) parameters in stored procedure scenarios. |
| OracleDataSource | Supported. You can use OracleDataSource or OracleClientFactory.CreateDataSource() to create a data source and obtain a connection. |
| OracleCommandBuilder | Supported. It supports the DeriveParameters static method, which automatically derives parameter information from a stored procedure. |
| OracleClientFactory | Supported. It implements DbProviderFactory and can create objects such as OracleConnection, OracleCommand, OracleCommandBuilder, and OracleDataSource. |
Interfaces not supported
OracleDataAdapter.