Science, Tech, Math › Computer Science ORM for Delphi Object Relational Mapping/Persistence Frameworks for Delphi Share Flipboard Email Print Mina De La O/Getty Images Computer Science Delphi Programming Delphi Tutorials Database Applications Advanced PHP Programming Perl Python Java Programming Javascript Programming C & C++ Programming Ruby Programming Visual Basic View More 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 Twitter Twitter 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. Cite this Article Format mla apa chicago Your Citation Gajic, Zarko. "ORM for Delphi." ThoughtCo, Aug. 28, 2020, thoughtco.com/orm-for-delphi-1058346. Gajic, Zarko. (2020, August 28). ORM for Delphi. Retrieved from https://www.thoughtco.com/orm-for-delphi-1058346 Gajic, Zarko. "ORM for Delphi." ThoughtCo. https://www.thoughtco.com/orm-for-delphi-1058346 (accessed January 21, 2021). copy citation