ORM for Delphi

Object Relational Mapping/Persistence Frameworks for Delphi

Computer data

Mina De La O/Getty Images 

By
Zarko Gajic
Computer Science Expert
  • MSCS, Computer Science, University of Osijek
Zarko Gajic is experienced in SQL and has working knowledge of DB systems such as MS SQL Server, Firebird, Interbase, and Oracle. He is also proficient in XML, DHTML, and JavaScript.
our editorial process
Zarko Gajic
Updated February 12, 2019

Working with database data in Delphi can be really simple. Drop a TQuery on a form, set the SQL property, set Active and there's your database data in a DBGrid. (You do also need a TDataSource and a connection to a database.)

Next, you'll want to insert, update and delete data, and introduce new tables. That's also easy but can get messy. It can take some finagling the correct SQL syntax before you can lay it out correctly. What is supposedly a simple task becomes slightly cumbersome.

Can all this be done relatively easily? The answer is yes—as long as you use an ORM (Object Relational Mapper).

hcOPF: an ORM for Delphi

This Open Source Value Type Framework provides a base class (ThcObject) composed of attribute objects that can be automatically persisted to an object store (normally an RDBMS). An object persistence framework is essentially a library of pre-written code that takes care of the details of persisting or permanently storing an object. The object may be persisted to a text file, XML file etc., but in the business world it will most likely be to an RDBMS and for this reason, they are sometimes referred to as an ORM (Object Relational Mapper).

DObject

A macrobject DObject suite is an O/R Mapping component package to be used in Delphi. DObject O/R Mapping suite allows you to access database completely in the way of object-oriented. It includes OQL. Delphi, which is a strong-typed OQL (Object Query Language) based on native Delphi language, even you needn't write a single line of SQL statement based on the string.

SQLite3 Framework

The Synopse SQLite3 database Framework interfaces the SQlite3 database engine into pure Delphi code: database access, User Interface generation, security, i18n, and reporting are handled in a safe and fast Client/Server AJAX/RESTful model.

tiOPF

The tiOPF is an Open Source framework for Delphi that simplifies the mapping of an object oriented business model into a relational database.

TMS Aurelius

ORM framework for Delphi with full support for data manipulation, complex and advanced queries, inheritance, polymorphism, and more. Supported databases: Firebird, Interbase, Microsoft SQL Server, MySQL, NexusDB, Oracle, SQLite, PostgreSQL, DB2.