Net4x.DapperLibrary.Firebird 1.9.9

DapperLibrary.Firebird

Provider-specific integration for Firebird (using FirebirdSql.Data.FirebirdClient) into the DapperLibrary surface.

Overview

Main types:

• FirebirdDapperContext � DapperContext implementation wired for Firebird.
• FirebirdProviderFactory � provider factory that configures parameter handling and adapter events for Firebird.
• FirebirdDatabaseModel, FirebirdDatabaseModelTypes, FirebirdDatabaseEnumTypes � Firebird-specific database model, SQL type mappings and enum type values.

Key behaviors and defaults

• Identifier delimiters: " (double quotes).
• Parameter prefix: : (colon).
• Batch/statement terminator: ;.
• Default IdentityInitializer for Firebird is set to GENERATED BY DEFAULT AS IDENTITY where applicable.
• Date/time formatting uses Firebird TIMESTAMP literal: e.g. TIMESTAMP 'yyyy-MM-dd HH:mm:ss'.
• ParameterModel.AddIndex = true is enabled and PrepareCommandParameters is used to normalize parameters for the provider.
• DbDataAdapter events (RowUpdating, RowUpdated) are hooked and forwarded into the library event model.

Usage

Create a context directly:

using var context = new FirebirdDapperContext();
// use context.Operations, context.Schema, context.SaveDataTable, etc.

Register the Firebird context with the global factory so callers using DapperContextFactory.Instance receive a Firebird-backed context:

// Register default creator
FirebirdDapperContext.Use();

// Register a context creator from an explicit connection string and provider
FirebirdDapperContext.Use("User=SYSDBA;Password=masterkey;Database=...;DataSource=...;", "Firebird.Data.FirebirdClient");

// Register once (adds disposal handling that cleans up created contexts)
FirebirdDapperContext.UseOnce();

When the context is created via the registered creator, the DatabaseModel is adjusted for Firebird semantics (identity generator, datetime formatting, etc.).

Notes and recommendations

• Use the Firebird ADO.NET provider matching your target runtime. The project expects FirebirdSql.Data.FirebirdClient.
• Firebird uses sequences/generators historically; newer Firebird versions support identity columns � the library configures the IdentityInitializer accordingly when creating contexts.
• The library configures parameter and type mappings suitable for Firebird; if you need custom type strings or delimiters, provide a custom DatabaseModel or override the model types.
• When using the in-process embedded or server Firebird instances, ensure connection string and client libraries are set up properly for your environment.

License / Contributing

See repository root for license and contribution guidelines.