Announcements · Sep 4, 2026 · 4 min read

Preview Support for EnterpriseDB is Now Available in RepoDB

We are excited to announce the preview release of EnterpriseDB support for RepoDB — bringing our hybrid ORM’s fluent CRUD, raw-SQL, and Bulk Operations capabilities to EDB Postgres Advanced Server for the first time, right out of the gate.

What’s in this preview?

The new RepoDb.EnterpriseDb package brings the full RepoDB experience to EnterpriseDB, built on top of the official EnterpriseDB.EDBClient driver:

Full CRUD operations — Insert, Query, Update, Delete, and Merge
Raw-SQL operations — ExecuteQuery, ExecuteNonQuery, ExecuteScalar, and ExecuteReader, for when you need full control over the statement being sent to the server
Bulk operations, via RepoDb.EnterpriseDb.BulkOperations — BulkInsert, BulkUpdate, BulkDelete, BulkDeleteByKey, and BulkMerge, built on a genuine binary COPY-protocol bulk load rather than a row-by-row loop — see EnterpriseDB Connector below for what powers it

It follows the same programming model you already use with our SQL Server, PostgreSQL, MySQL, SQLite, Oracle, DB2, MariaDB, Firebird, Vertica, and SAP HANA extensions — the same fluent API, the same lightweight philosophy, now targeting EnterpriseDB.

Why EnterpriseDB?

EDB Postgres Advanced Server is the enterprise-hardened, Oracle-compatible PostgreSQL distribution many regulated and large-scale shops standardize on when they need PostgreSQL with commercial support, security certifications, and Oracle-migration features baked in. It’s PostgreSQL-adjacent but not PostgreSQL — close enough that teams expect a familiar experience, different enough that a provider built specifically for it, rather than assumed compatible by accident, is worth having. This preview gives EDB Postgres Advanced Server users the same fast, hybrid data-access experience RepoDB is known for elsewhere.

EnterpriseDB Connector

The package is powered by RepoDb.Connector.EnterpriseDb — the Npgsql-backed EnterpriseDB connector from our RepoDB Connectors project. It supplies EDBBulkCopy (built on Npgsql’s native binary COPY protocol) and the EDBConnection type the bulk operations package is built against — distinct from the official EnterpriseDB.EDBClient.EDBConnection driver used by the core provider.

The EDB prefixes on this connector’s objects (EDBConnection, EDBBulkCopy, and the rest) are intentional, for API compatibility — so that users can switch to the official EnterpriseDB NuGet package with less restrictions and less code modifications.

Getting started

Install the packages:

> Install-Package RepoDb.EnterpriseDb -Version 0.0.1-alpha
> Install-Package RepoDb.EnterpriseDb.BulkOperations -Version 0.0.1-alpha

Initialize it once at startup:

GlobalConfiguration
    .Setup()
    .UseEnterpriseDb();

Basic CRUD

Insert

using var connection = new EDBConnection(connectionString);
var person = new Person { Name = "John Doe", Age = 30, CreatedDateUtc = DateTime.UtcNow };
var id = connection.Insert(person);

Query

using var connection = new EDBConnection(connectionString);
var person = connection.Query<Person>(e => e.Id == 10045).FirstOrDefault();

Update

using var connection = new EDBConnection(connectionString);
var person = connection.Query<Person>(e => e.Id == 10045).FirstOrDefault();
person.Age = 31;
var updatedRows = connection.Update(person);

Delete

using var connection = new EDBConnection(connectionString);
var deletedRows = connection.Delete<Person>(10045);

Merge

using var connection = new EDBConnection(connectionString);
var person = new Person { Id = 10045, Name = "John Doe", Age = 32, CreatedDateUtc = DateTime.UtcNow };
var id = connection.Merge(person);

Raw-SQL

ExecuteQuery

using var connection = new EDBConnection(connectionString);
var people = connection.ExecuteQuery<Person>("SELECT * FROM \"Person\" ORDER BY \"Id\" ASC;");

ExecuteNonQuery

using var connection = new EDBConnection(connectionString);
var affectedRows = connection.ExecuteNonQuery("DELETE FROM \"Person\" WHERE \"Id\" = @Id;",
    new { Id = 10045 });

ExecuteScalar

using var connection = new EDBConnection(connectionString);
var maxId = connection.ExecuteScalar<long>("SELECT MAX(\"Id\") FROM \"Person\";");

Bulk Operations

Bulk operations require the EnterpriseDB Connector’s EDBConnection, not the official driver’s connection type of the same name.

BulkInsert

using var connection = new EDBConnection(connectionString);
// Streamed through EDBBulkCopy's native binary COPY protocol
var people = GetPeopleToInsert();
var insertedRows = connection.BulkInsert(people);

BulkMerge

using var connection = new EDBConnection(connectionString);
var people = GetPeopleToMerge();
var mergedRows = connection.BulkMerge(people, qualifiers: e => e.Id);

BulkDeleteByKey

using var connection = new EDBConnection(connectionString);
var keys = new long[] { 10045, 10046, 10047 };
var deletedRows = connection.BulkDeleteByKey("Person", keys);

A preview, not a final release

As a preview package at v0.0.1-alpha, RepoDb.EnterpriseDb (and its Bulk Operations counterpart) is still maturing — APIs and behavior, including the caveats described above, may change before a stable release ships. We would love to hear your feedback as you try it out; it directly shapes what we prioritize on the way to general availability.

~ Conceptualized by me. Reviewed and checked by AI. Refined and gatekept by me. ~