Avoid the tedious SQL statements that you can verify properly and code directly with object using this comprehensive library with ORM framework support
TMS Aurelius is a framework for Delphi which comes with support for data manipulation, complex or advanced queries, as well as inheritance and polymorphism. The library can be particularly useful for anyone working with ORM frameworks, as you can work the code directly with objects, instead of relying on complex SQL statements that can only be verified at runtime.
A further noteworthy advantage of the library steam from the fact that you can hide all the database-access layer and hence, present a clearer business logic to your potential customers. Nevertheless, if necessary, you can alter the underlying database, but without modifying the actual code, since you are working with objects directly.
The set of components is compatible with several types of servers, including, but not limited to MS SQL, Firebird, MySQL, DB2, Oracle or Interbase. Moreover, it supports various database-access components, such as AnyDAC, SQLDirect, IBX, dbExpress or ADO, for instance.
Working with the components entails a lot of versatility and hence, you can perform queries with expressions, grouping or conditions, choose from the classes-to-database approach and vice versa, work with cached and identity-mapped objects, logging of SQL commands, mapping types of database values or using different mapping models into a single application.