TMS Aurelius is a Delphi ORM (Object-Relational Mapping) framework that provides full support for data manipulation using pure object-oriented code. It replaces the need for writing complex SQL statements by enabling developers to work directly with classes that map seamlessly to database structures. Aurelius supports advanced querying, inheritance, polymorphism, association mappings, and cross‑database development. The framework is designed to improve productivity, maintainability, and portability of database-driven Delphi applications by providing a high‑level API for data access. With support for multiple database servers and database-access technologies, Aurelius offers a modern ORM layer with features such as lazy loading, nullable types, automatic SQL generation, and integration with TMS Data Modeler.

Features

• 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 Database & Component Support
• Supports several database servers (MS SQL Server, Firebird, MySQL, DB2, Interbase, Oracle, …)
• Supports several database-access components (dbExpress, AnyDac, SQLDirect, ADO, IBX, …)
• Multi-platform solution: Win32, Win64, macOS, VCL, FireMonkey

Benefits

• Productivity: Avoid complex SQL statements that can only be verified at runtime. Code directly with objects.
• Maintainability: Clearer business logic by dealing with objects, hiding all the database-access layer.
• Portability: Easily change the underlying database - all your business code stays the same since they are just pure objects.