OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase Connector/NET

V1.1.0
  • What Is OceanBase Connector/NET
    • Introduction
  • Install and Connect
    • Installation process
    • Test the connection
    • Package reference and usage
    • Compatibility impact
  • User Guide
    • Quick Start
      • Complete example
    • Connection Strings and Data Source
      • Connection strings
    • Data Types
      • Overview of data types
    • Command and Parameter
      • Overview
    • Result Set
      • Supported result set types
    • ORM and Frameworks
      • Use Entity Framework Core
      • Use SqlSugar
      • Use FreeSql
  • Reference Information
    • Common Interfaces
      • Overview of commonly used interfaces
  • Version Release Records
    • OceanBase Connector/NET V1.0.0
    • OceanBase Connector/NET V1.1.0

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase Connector/NET
  3. V1.1.0

OceanBase Connector/NET V1.1.0

Last Updated:2026-09-04 08:24:51

Version information
Version overview
Key features
EF Core 8 compatibility
SqlSugar compatibility
FreeSql compatibility
Compatibility changes
Configuration parameter changes
Supported OBServer versions
Critical bug fixes
Documentation and examples

Version information

  • Release date: April 22, 2026
  • Version number: V1.1.0 (Base driver package: OceanBase.ManagedDataAccess.1.1.0)
  • ORM framework compatibility packages:
    • OceanBase.EntityFrameworkCore8.1.0.0.nupkg
    • SqlSugarCore.OceanBase.1.0.0.nupkg
    • FreeSql.Provider.OceanBase.1.0.0.nupkg

Version overview

V1.1.0 focuses on compatibility with mainstream ORM frameworks, particularly EF Core, SqlSugar, and FreeSql. Developers can use OceanBase Oracle mode within ORM frameworks, reducing the need for low-level ADO.NET code and improving development efficiency and maintainability.

This version enhances Connector/NET's capabilities in the ORM ecosystem, providing more technical options for migrating .NET applications from Oracle to OceanBase. For .NET applications that already use ORM for data access, we recommend using this version for business development and migration validation.

Key features

EF Core 8 compatibility

The OceanBase.EntityFrameworkCore8.1.0.0.nupkg package enables access to OceanBase Oracle mode databases in EF Core 8.x. The provider is built on the OceanBase Connector/NET driver and is highly compatible with ODP.NET EF Core Provider.

Key features:

  • Supports DbContext integration
  • Supports Migrations and EnsureCreated
  • Full CRUD and transaction management
  • Supports common LINQ translations, including methods from DateTime, String, Math, and Convert types
  • Supports value generation, including HiLo sequences and Identity / Guid extensions
  • Provides execution strategies and retry mechanisms

Use cases: .NET applications using EF Core for data access, especially those migrating from Oracle EF Core Provider to OceanBase.

For more information, see Use Entity Framework Core.

SqlSugar compatibility

The SqlSugarCore.OceanBase.1.0.0.nupkg NuGet package enables access to OceanBase Oracle mode databases in SqlSugar. The compatibility layer leverages ADO.NET bridging to reuse SqlSugar's Oracle capabilities, with the underlying connection to OceanBase.ManagedDataAccess.

Key features:

  • Supports two connection methods: DbType.Custom (recommended for better compatibility) and DbType.OceanBaseForOracle
  • Supports CodeFirst table creation and DbFirst metadata reading
  • Full CRUD operations (Queryable, Insertable, Updateable, Deleteable)
  • Transaction support (Commit / Rollback)
  • Stored procedure and function calls (IN/OUT parameters, return values)
  • Parameterized queries and native SQL execution

Use cases: .NET Framework / .NET Core applications using SqlSugar for rapid development, seeking minimal changes for database migration.

For more information, see Use SqlSugar.

FreeSql compatibility

The FreeSql.Provider.OceanBase.1.0.0.nupkg package enables access to OceanBase Oracle mode databases in FreeSql, expanding ORM options for .NET developers.

Key features:

  • Supports CodeFirst and DbFirst
  • Full CRUD operations

Use cases: .NET applications using FreeSql for data access, requiring flexible ORM options.

For more information, see Use FreeSql.

Compatibility changes

Configuration parameter changes

Name
Change type
Description
AutoClosePreparedStatements New Controls whether to automatically close Prepared Statements. Enabling this prevents resource exhaustion due to Cursor accumulation under the PS protocol. Default value: True
AutoCommit New Controls whether to automatically commit transactions. Enabling this automatically commits after each statement, while disabling requires manual transaction management. Default value: True

Supported OBServer versions

Supported OBServer versions include OBServer 4.x, OBServer 3.x, and earlier versions.

We recommend using OBServer 4.x for better compatibility and performance.

Critical bug fixes

  • Fixed an error when inserting RAW type data under the PS protocol: ConvertToOracleColumnTypeAndFlags for LongRaw is not implemented
  • Fixed an error when passing date parameters as string: literal does not match format string
  • Fixed an issue where rs.close() under the PS protocol did not close stmt, leading to Cursor limits
  • Fixed an issue where Cursor release did not actively send COM_STMT_CLOSE, causing Cursor to persist in long-lived connections

Documentation and examples

We recommend reading the installation steps, connection string conventions, and runnable examples from the following links:

  • Use Entity Framework Core
  • Use SqlSugar
  • Use FreeSql

For information on installing the base driver and configuring package sources, see Package references and usage.

Previous topic

OceanBase Connector/NET V1.0.0
Last
on this page
Version information
Version overview
Key features
EF Core 8 compatibility
SqlSugar compatibility
FreeSql compatibility
Compatibility changes
Configuration parameter changes
Supported OBServer versions
Critical bug fixes
Documentation and examples