Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!

ORM For Delphi

orm for delphi

Object Relational Mapping is the idea of being able to write queries using the object-oriented paradigm in your preferred programming language. So this means we are trying to utilize our language to talk with the database instead of using SQL.

Why utilize ORM?

  • It abstracts away the database system, so switching is easy.
  • Your queries can be efficient than writing them with SQL.
  • With ORM, you get lots of features out of the box for instance
    • Transactions
    • Migrations
    • Seeds
    • Streams
    • Connection Pooling

Delphi community has several Delphi ORM libraries, and the DORM (Delphi ORM) by Daniele Teti is one of the popular and open-source libraries you can use.

DORM has many features available:

  • Database agnostic (Do not require database changes!)
  • Has one, has many, and belongs to relations support
  • Mapping through file, attributes, or CoC
  • Save and retrieve objects graph, not only single objects
  • External (file) or internal (resource, json stream) configuration
  • Interfaces based!
  • FirebirdSQL (using UIB)
  • Interbase (using UIB)
  • SQLServer (using FireDAC driver)
  • SQLite3 (using this SQLite3 wrapper
  • and more!

Here you can download the Delphi ORM!

embarcadero delphi delphi orm object resource mapping 4264149

Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

About author

Software Developer | CS(CyberSec) Undergrad at APU Malaysia | Delphi/C++ Builder Enthusiast | Microsoft Learn Student Ambassador | Microsoft Azure Certified


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.