Does anyone know about an ORM or something similar for Delphi Win32.
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:
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.
There are a few, some of the more tried and tested are...
And RemObjects also has a schema Mapping technology that is worth investigating
TMS Software is working on an ORM framework for Delphi: TMS Aurelius should be soon released :
EDIT: It's been already released, official site is http://www.tmssoftware.com/site/aurelius.asp
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.
New in 2011: DORM - http://code.google.com/p/delphi-orm/. Some documentation can be found on author's blog.
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.
Jazz SDK, ORM is a part of the OPF part
Here you have one: http://code.google.com/p/delphiorm/
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.
Trysil is a "lightweight" ORM for Delphi and supports:
- FirebirdSQL
- Microsoft SQL Server
- PostgreSQL
- SQLite.
© 2022 - 2024 — McMap. All rights reserved.