6

SUPPORT

• Contact Support

TRIAL DOWNLOADS

• Delphi 2010 (6.68 MB)
• Delphi XE (7.09 MB)
• Delphi XE2 (6.65 MB)
• Documentation (3.02 MB)

Purchase a license

BOOKMARKS

TMS Aurelius

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

• Feature overview
• Version history
• Related blog entries
• Online manual
• Supported databases
• Supported platforms
• Supported Data-Access components
• Comments
• Buy online

Feature overview

Benefits

Aurelius brings all benefits an application can obtain from using an ORM framework:

• Productivity: Avoid complex SQL statements that can only be verified at runtime. Code directly with objects.
  It's basically something that prevents you from writing code like this:
  

  Query1.Sql.Text := 'SELECT I.ID AS INVOICE_ID, I.INVOICE_TYPE, I.INVOICE_NO, I.ISSUE_DATE, I.PRINT_DATE, ' +
    'C.ID AS CUSTOMER_ID, C.CUSTOMER_NAME, C.SEX, C.BIRTHDAY, N.ID AS COUNTRY_ID, N.COUNTRY_NAME' +
    'FROM INVOICE AS I INNER JOIN CUSTOMER AS C ON (C.ID = I.CUSTOMER_ID) ' +
    'LEFT JOIN COUNTRY AS N ON (N.ID = C.COUNTRY_ID)' +
    'WHERE I.ID = :INVOICE_ID;'
  Query1.ParamByName('INVOICE_ID').AsInteger := 1;
  Query1.Open;
  ShowMessage(Format('Invoice No: %d, Customer: %s, Country: %s',
    [Query1.FieldByName('INVOICE_NO').AsInteger,
    Query1.FieldByName('CUSTOMER_NAME').AsString,
    Query1.FieldByName('COUNTRY_NAME').AsString])); 

  and instead write this:
  

  Invoice := Manager1.Find<TInvoice>(1);
  ShowMessage(Format('Invoice No: %d, Customer: %s, Country: %s',
    [Invoice.InvoiceNo, Invoice.Customer.Name, Invoice.Customer.Country.Name]));

• 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.

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, Mac OS X, VCL, FireMonkey
• Saving, updating and loading of entity objects in an object-oriented way
• 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

Supported platforms

• Windows 32-Bit
• Windows 64-Bit
• Mac OS X

Supported Data-Access components

• dbExpress
• dbGo (ADO)
• Interbase Express (IBX)
• SQLite - Native Support
• AnyDac
• NexusDB
• SQL-Direct
• IBObjects

Comments

I've played with the trial of Aurelius a bit and I like what I've seen so far (Firebird 2.5 with IBObjects). Especially the way how I can get started with a legacy database is nice. I wouldn't like if Aurelius thinks it needs to be clever when it comes to maintaining the underlaying database for changes due to the technical challenges mentioned above. For sure, Aurelius has potential for being an important part in the Delphi world when writing OO-based database clients.

Thomas Steinmaurer / Firebird Technology Evangelist, via email

Time-limited special offer: Save 20% on TMS Aurelius, offer until February 29!

With the new release of TMS Aurelius v1.0, we have a special time-limited discount offer. Until February 29, 2012, all users receive 20% discount on all new orders of new licenses:

• TMS Aurelius Single developer license: now 156 EUR instead of 195EU, you save 39 EUR!
• TMS Aurelius Small team license: now 236 EUR instead of 295EU, you save 59 EUR!
• TMS Aurelius Site license: now 556 EUR instead of 695EU, you save 139 EUR!

To take advantage of this discount offer, after selecting your payment type in the online order form, enter your valid coupon code TMS-AURELIUS-2012 in the field labeled "Your coupon code". The discount that comes with your coupon is applied after you have completed entering your personal data and have been redirected to the second page of the online order process.

Buy online

This product is also available in the following bundle(s):

1. TMS Aurelius - Data Modeler bundle

TMS Aurelius - Data Modeler bundle
View licensing FAQ
1. License for commercial use
2. Free 2 year updates and new releases
3. Free priority support through email, newsgroup and forum
€ 255
Single developer license
for 1 developer
order now or add to cart

€ 395
Small team license
for 2 developers
order now or add to cart

€ 895
Site license for unlimited
developers in the company
order now or add to cart