OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview
DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview
DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

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

Introduction Installation process Test the connection Package reference and usage Compatibility impact Complete example Connection strings Overview of data types Overview Supported result set types Use Entity Framework Core Use SqlSugar Use FreeSql Overview of commonly used interfaces OceanBase Connector/NET V1.0.0 OceanBase Connector/NET V1.1.0
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogLive DemosTraining & Certification
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Connector/NET
  3. V1.1.0
iconOceanBase Connector/NET
V 1.1.0
  • V 1.1.0
  • V 1.0.0

OceanBase Connector/NET V1.1.0

Last Updated:2026-04-28 03:38:03  Updated
share
What is 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

folded

share

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
What is 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