Description

ORM framework for Delphi with full support for data manipulation, complex and advanced queries, inheritance, polymorphism, and more...

Feature details

Several database servers supported (MS SQL Server, Firebird, MySQL, DB2, Interbase, Oracle,...)

Several database-access components supported (dbExpress, AnyDac, SQLDirect, ADO, IBX,...)

Multi-platform solution - Win32, Win64, macOS, VCL, FireMonkey

Saving, updating and loading of entity objects in an object-oriented way

TAureliusDataSet for easy and fast interfacing to DB-aware controls in VCL

Multi-model design to allow different mapping models in a single application

Queries - Powerful query API using criteria expressions, projections, grouping, conditions and even logical operators in a LINQ-like approach

Inheritance mapping and polymorphism - map a full class hierarchy into the database

Cross-database development - use a single Delphi code to target multiple databases in a transparent way

Choose from classes-to-database approach (creating the database structure from classes) or database-to-classes approach (creating classes source code from database, using TMS Data Modeler )

Mapping directly in classes using custom attributes

Association mapping

Lifetime management of objects using object manager

Cached and identity-mapped objects

Automatic database structure generation

Nullable types support

Lazy loading for associations and blob fields

Allows logging of SQL commands

Allows mapping enumerated types to database values

Open architecture - easy extendable to use different component sets or database servers

Supported databases

Firebird

Interbase

Microsoft SQL Server

MySQL

NexusDB

Oracle

SQLite

PostgreSQL

DB2

ElevateDB server

Absolute Database

Supported platforms

Windows 32-Bit

Windows 64-Bit

macOS

iOS

Android

Linux

Supported Data-Access components

dbExpress

dbGo (ADO)

FIBPlus

Interbase Express (IBX)

SQLite - Native Support

AnyDac

NexusDB

SQL-Direct

IBObjects

ElevateDB

UniDac

UIB

Direct Oracle Access

FireDac

ZeosLib

Additional Information