Part of Anarchy I/O Toolkit, a .NET developer platform · Pillar: Infrastructure · Layer: Infrastructure · Package catalog

Oracle adapter for the toolkit’s relational persistence layer, using ODP.NET.

dotnet add package Anarchy.Toolkit.Infrastructure.Persistence.Db.Oracle
  • OracleDbDialect, connection pools, unit of work, resilience policy and repository bases adapt the shared relational layer to Oracle.
  • Register ModuleOracle with connection and resilience options factories; AddOracleHealthReports() or ModuleOracleHealthReport adds reader and writer checks.
  • OracleConnectionOptions.DbName is the service name; the default port is 1521. The connection pool applies command timeout and session time zone settings.
  • Oracle SQL must use :Name binds and must not end in a semicolon. Use Testing.Db.Oracle for test helpers.

When to use it

Use this adapter when relational persistence runs on Oracle and your application needs the shared toolkit repository and unit-of-work model. The adapter supplies the ODP.NET integration, not the application schema, migrations or concrete event-store SQL.

How to use it

  1. Register AppTelemetry, then use ModuleOracle with factories that build OracleConnectionOptions and OracleResilienceOptions from your host configuration. The module guide shows the equivalent factory pattern for PostgreSQL.
  2. Configure reader and writer hosts, credentials, Oracle service name, time zone and command timeout; set MaximumPoolSize if the default of 100 is unsuitable. A null port selects 1521.
  3. Implement concrete repositories using the Oracle bases and Oracle-compatible SQL. Use the reader and writer keyed policies as appropriate; the unkeyed policy uses the writer.
  4. Add Oracle health reports when the host exposes service health, and exercise the real adapter with Testing.Db.Oracle against a dedicated test schema.

See the Oracle and persistence notes and toolkit overview.

Releases

See the release notes for the complete release history.