ORM for DELPHI win32

Question

Does anyone know about an ORM or something similar for Delphi Win32.

Answer 1

Marco Cantu is a big believer in InstantObjects:

http://www.instantobjects.org/

Others include DObject:

http://www.macrobject.com/en/dobject/

and tiOPF

http://tiopf.sourceforge.net/Doc/overview/index.shtml

You also might be interested in the G Framework:

http://code.google.com/p/g-framework/

Answer 2

Here you have one: http://code.google.com/p/delphiorm/

Answer 3

TMS Software is working on an ORM framework for Delphi: TMS Aurelius should be soon released :

TMS Aurelius

EDIT: It's been already released, official site is http://www.tmssoftware.com/site/aurelius.asp

Answer 4

New in 2011: DORM - http://code.google.com/p/delphi-orm/. Some documentation can be found on author's blog.

Answer 5

Trysil is a "lightweight" ORM for Delphi and supports:

• FirebirdSQL
• Microsoft SQL Server
• PostgreSQL
• SQLite.

https://github.com/davidlastrucci/Trysil

Answer 6

Another ORM for Delphi, which seems to be in active development, is hcOPF

The project is open source licensed under LGPL/MPL and hosted on SourceForge at http://sourceforge.net/projects/larryhengensopf/.

---

dorm, “The Delphi ORM” by Daniele Teti, was officially published at ITDevCon, there is an introduction here. It works with PODOs which have no knowledge of the ORM.

Answer 7

Another Open Source ORM for Delphi 6-XE2, which is JSON based and Client/Server.

Can use its own in memory database layer or embedded SQLite3 database engine: http://blog.synopse.info/category/Open-Source-Projects/SQLite3-Framework

Edit: A lot of improvements to this active framework, since this question was answered. It is able now to connect to any third-party database, and is changing its name: it is now called the mORMot framework.

Answer 8

There are a few, some of the more tried and tested are...

Bold

TiOPF

And RemObjects also has a schema Mapping technology that is worth investigating

Answer 9

Jazz SDK, ORM is a part of the OPF part

http://jazz-sdk.googlecode.com

Answer 10

Visit http://code.google.com/p/persiphi/ if your are addicted to Delphi 2010 or upper.

Edit: Dead link as the owner likely has renounced to opensource it. Nevertheless, his master thesis work in portugese (pt-br) is still available here. A good source of inspiration for those in search of sample using latest bleeding edge features of Delphi (Annotation, Rtti...) in the realm of object persistence.

---

UPDATE 1:

DevArt has released EntityDAC - An ORM for Delphi with LINQ support!

It works even with D11 (Delphi 2007).

---

UPDATE 2:

Marshmallow ORM framework by Linas Naginionis.

It has joined join the outstanding Spring4D project as a feature branch as announced here.

To keep abreast of the latest news head to the Marshmallow Google+ thriving Community page.

Dubbed MM ORM Framework by its author, it's a promising one.

Answer 11

I tried Remobject Data Abstract for 1-2 year in some real world projects.

Some features are good (a very good binary comunication protocol), some other are simply pitfalls (it adds a something of chaotic code and you have to pass dialog by dialog every change you made on the schema).

It's good you define a schema of the model, it's bad you miss much of the power of SQL (es grouping by, a easy to use join, ecc).

I think that it's hard to fit a good ORM on top of the old VCL and TDataSet.

DatAbstact was a try but at the end I rewrited my application in another language because a good ORM and a good framework is a must have for a good application.

VCL is simply too old to fit well with modern concepts of application development.

Anyway i tried InstantObject and Bold, are two good ORM frameworks but not more supported.