EntitySpaces.ORM.OracleManagedClient.NET 2026.8.0

<img src="https://es-banner.paul-netstep.workers.dev?src=nuget_readme" alt="EntitySpaces" width="531" height="268">

EntitySpaces.ORM.OracleManagedClient.NET

Part of the modernized EntitySpaces ORM — Oracle data provider. Actively maintained fork with full .NET Framework 4.8 to .NET 10 support.

Supportability

❤️ Support this project

If this provider has saved you time on a project, support its development — every contribution helps keep it free and maintained.

You can also sponsor via the ❤️ Sponsor link on this NuGet package (powered by Ko-fi).

📋 Help Shape the Roadmap

Take the 3‑minute survey – your feedback keeps EntitySpaces alive and evolving.

🛠️ Requires EntitySpaces Studio

This package provides the SQL Server runtime only — it does not generate code. Entity and Collection classes are generated from your database schema using EntitySpaces Studio, a separate WinForms tool.

• Get it from the repo: EntitySpaces.Studio
• Download the most recent .zip — avoid any file tagged -deprecated, that build is kept for reference only.
• Connect to your database under Settings → Connection, then run the Generated and Custom class templates.

New Features

• Oracle Cloud (Autonomous Database) connection support via wallet-based TLS mutual authentication
• Concurrency exception detection — custom stored-proc errors, unique constraint violations, deadlocks, and serialization failures all translate to esConcurrencyException
• Connection pool safety — hasError flag + ROLLBACK in finally, preventing aborted-transaction connections from being reused
• Oracle Identity columns (GENERATED BY DEFAULT AS IDENTITY, 12c+) detected via ALL_TAB_COLUMNS.IDENTITY_COLUMN
• NUMBER(p,s) correctly mapped to decimal in generated C# code for monetary/high-precision values
• Navigation properties (UpTo) generated from FK metadata in ALL_CONSTRAINTS / ALL_CONS_COLUMNS
• Thread-safe parameter cache — upgraded from a locked Dictionary to a lock-free ConcurrentDictionary, improving throughput under concurrent load
• .NET 8 compatibility — explicit ConfigurationManager.OpenExeConfiguration call added, required because .NET 8 no longer auto-binds the oracle.manageddataaccess.client app.config section
• Studio metadata engine rewritten to use ODP.NET Managed instead of the legacy OLE DB driver

Fixes

• CreateConnection() now correctly returns an OracleConnection — it previously returned OleDbConnection, which caused silent failures
• The Delimiters class was corrected to use single quotes for string literals and double quotes for identifiers — both were previously set to double quotes, which caused ORA-00911 (invalid character) on string comparisons
• Documented the correct cleanup pattern for TransactionScope with ODP.NET Managed (which doesn't support DTC/MSDTC) — use TransactionScopeOption.Suppress or the provided RunWithoutTransaction helper to avoid "transaction within transaction" errors during error cleanup

Dependency Updates

• Updated System.Configuration.ConfigurationManager from 10.0.10 to 10.0.11
  • Maintenance release. No API changes affecting EntitySpaces.

Quick Samples

Load a collection:

var customers = new CustomersCollection();
customers.LoadAll();

foreach (var customer in customers)
{
    Console.WriteLine(customer.CompanyName);
}

Create, update, delete an entity:

var employee = new Employees();
employee.FirstName = "Joe";
employee.LastName = "Smith";
employee.Save();               // Create

employee.LastName = "Doe";
employee.Save();               // Update

employee.MarkAsDeleted();
employee.Save();               // Delete

Oracle connection string:

esProviderFactory.Factory = new EntitySpaces.Loader.esDataProviderFactory();

esConnectionElement conn = new esConnectionElement();
conn.Provider = "EntitySpaces.OracleManagedClientProvider";
conn.ConnectionString =
    "Data Source=(description=(retry_count=20)(retry_delay=3)" +
    "(address=(protocol=tcps)(port=1522)(host=your-host.oraclecloud.com))" +
    "(connect_data=(service_name=your_service_name)));User Id=ADMIN;Password=mypassword;";
esConfigSettings.ConnectionInfo.Connections.Add(conn);

More usage examples (joins, paging, transactions, and the full Fluent SQL API): see the main EntitySpaces README.

Generating your entity classes

See Requires EntitySpaces Studio above.