Products



Stay in touch

Add your e-mail address here to receive the monthly TMS Software alerts.


    
PRODUCTS / DEVELOPER TOOLS / TMS AURELIUS
v2.6.3 (Apr 9, 2015)


TMS Aurelius

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

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

Extensive online documentation

Screenshots

Supported databases



  • Firebird
  • Interbase
  • Microsoft SQL Server
  • MySQL
  • NexusDB
  • Oracle
  • SQLite
  • PostgreSQL
  • DB2
  • ElevateDB server
  • Absolute Database

Supported platforms

TMS Aurelius iOSandroid

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

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

Videos

Introducing TMS Aurelius. An ORM framework for Delphi

Wagner Landgraf is giving a presentation on our Delphi ORM TMS Aurelius. This introduction will help you quickstart using the TMS Aurelius framework for writing effective database driven Delphi applications in a productive way.

Testimonials

TMS Aurelius makes my code to be very clean. I can code in pure OOP, not worrying about database persistence or SQL statements, being able to switch connetions and database servers very easily. My development speed has increased significantly.

Carlos Fitl, via email


It's now very easy to build a report with the new Flexcel + Aurelius integration. It was so easy that I really thought I was doing something wrong. I will never go back to a report generator, Flexcel is way cooler and easier for reports”

Eduardo Elias / Yashar software, via email


From what I've seen so far, I think this is going to revolutionize my app development - can't wait to start playing with the features now!

Dave White via TMS Forum


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


TMS Aurelius is really some awesome piece of technology that has been missing from Delphi for years. REALLY good framework that is well thought-through. Believe me, I have had my look at a fair number of ORMs.

Holger Flick via email

Buy online

TMS Aurelius
for Delphi 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8 (Prof/Enterprise/Architect)


View licensing FAQ
  1. License for commercial use: Single developer license, Small team license, Site license
  2. Includes full source code
  3. Free 2 year updates and new releases
  4. Free priority support through email and forum

Single developer license
for 1 developer

€ 195

 

Small team license
for 2 developers

€ 295

Site license
for unlimited
developers
in the company

€ 695




CreditCards Accepted


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

  1. TMS Aurelius - Data Modeler bundle
  2. TMS Business Subscription

Copyright © 1995 - 2015 TMS Software v4.0


Being a fan of the Sakura replica watches Wars (Sakura Taisen) franchise, when I pop replica handbags this disc replica louis vuitton into my player, never in my life replica handbags was I so excited (well along with the rolex replica last volume of Princess Nine since louis vuitton replica it came with my order) to see this second OAV series. Can you tell what I think about this show?On chanel replica the first episode on the disc, it's chanel replica basically a story about Maria's past coming back to haunt her. A shady character, by the rolex replica name of Valentinov, comes to Japan looking to exact revenge rolex replica on Maria. He sets up bombs in the Imperial Theatre, which forces Maria breitling replica to come face with the past she wanted to leave behind.