Reputation: 4555

ORM for DELPHI win32

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

Upvotes: 33

Answers (11)

David Lastrucci

Reputation: 1

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

FirebirdSQL
Microsoft SQL Server
PostgreSQL
SQLite.

https://github.com/davidlastrucci/Trysil

Upvotes: 0

menjaraz

Reputation: 7575

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!

EntityDAC

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.

Upvotes: 3

robertom

Reputation: 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.

Upvotes: 1

Mohamad

Reputation: 1117

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

Upvotes: 9

gabr

Reputation: 26850

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

Upvotes: 5

mjn

Reputation: 36664

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.

Upvotes: 6

Arnaud Bouchez

Reputation: 161

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.

Upvotes: 11