dibrORM

dibrORM is an open-source object-relational mapper designed to simplify data access in modern applications. It provides a code-first approach that maps database tables to domain objects and supports pluggable database dialects to work with PostgreSQL, MySQL, SQLite, and SQL Server.

Key features include code-first modeling, automatic migrations, a fluent query API, lazy and eager loading of relations, and robust relationship management for one-to-many and many-to-many associations. It supports transactions, asynchronous operations, and change tracking through a unit-of-work pattern, plus a lightweight caching layer.

Architecture: The core consists of a model metadata engine, a dialect-aware query translator, a migration subsystem, and a session or unit-of-work manager. Dialects are implemented as adapters, allowing behavior differences across backends without changing application code. The metadata layer uses reflections to map classes to tables and to define relationships and constraints. The query translator converts high-level expressions into SQL tailored to the active dialect.

Development and licensing: dibrORM is distributed under the MIT license and is maintained by a community-driven repository with emphasis on documentation and tests. Contributions are welcomed through issue trackers and pull requests, with periodic releases and a focus on compatibility and low dependency footprint.

Usage overview: developers define domain models, configure a database connection and dialect, and use the session to query, insert, update, and delete objects. The ORM translates expressions into SQL, applies migrations, and keeps track of object state during a unit of work, enabling consistent and efficient data operations.