Link Search Menu Expand Document

Operations (Firebird)

RepoDB’s standard operations (Query, Insert, Merge, Update, Delete, etc.) all work against FbConnection once UseFirebird() has been called. Firebird has no dedicated bulk-operations package (unlike SQL Server, Oracle, PostgreSQL, MySQL, MariaDB, Db2 and ClickHouse) — InsertAll, MergeAll and UpdateAll are the only options for writing multiple rows.

SQL generation notes

FirebirdStatementBuilder generates Firebird-flavored SQL for every operation:

  • FIRST n for top-N Query/Exists, and FIRST m SKIP n for BatchQuery/skip-take queries — Firebird has no TOP/LIMIT keyword.
  • Insert/Merge read back the generated key via Firebird’s native RETURNING clause, which (unlike Oracle) surfaces directly as an ordinary single-row result set — no PL/SQL block or output-parameter wrapping needed.
  • Merge/MergeAll compile to UPDATE OR INSERT INTO ... MATCHING (...) RETURNING ..., Firebird’s native single-statement upsert. When the identity column is itself a qualifier, an EXECUTE BLOCK is used instead (see FirebirdStatementBuilder for details), since MATCHING cannot reliably match a not-yet-inserted row on its own not-yet-known identity value.
  • Truncate compiles to a plain DELETE FROM t — Firebird has no TRUNCATE TABLE statement (as of 5.0) — which does not reset a GENERATED ... AS IDENTITY column’s next value.

No table hints

FirebirdDbSetting.AreTableHintsSupported is false. Passing a non-null hints argument to any operation throws a NotSupportedException.

One row per round trip for the *All operations

FirebirdDbSetting.IsMultiStatementExecutable is false — FbCommand cannot execute multiple statements in a single round trip. InsertAll, MergeAll and UpdateAll issue one statement per row instead of a single batched command; passing an explicit batchSize greater than 1 to any of them throws a NotSupportedException.

No session-wide scope identity

GetScopeIdentity/GetScopeIdentityAsync always throw NotSupportedException — Firebird has no construct equivalent to SQL Server’s SCOPE_IDENTITY() or MySQL’s LAST_INSERT_ID(). The generated key is already returned directly by Insert/Merge via RETURNING; query the underlying generator explicitly (e.g. GEN_ID(generator_name, 0)) if you need it out-of-band.

Async Methods

All the provided synchronous operations have an equivalent asynchronous (Async) counterpart.

Table of contents