Object Relational Database Development

[PeterMoris]

There are plenty of Object to relational mapping tools available in the market, but we don't know the strengths and weaknesses of each. Let’s share our experiences with O/R mapping products to the others.

Please comment which of the following products you’ve used and what was the outcome. Feel free to add more tools to the list.

NPersist
TierDeveloper
EntityBroker
DeKlarit
Lattice.DataMapper
LLBGen Pro
XPO eXpress Persistent Objects
Nolics.net O/R mapper
Wilson ORMapper
NHibernate
MyGeneration

[ShaunRay]

I have used TierDeveloper personally and I’m very much satisfied with the product. Here are some of the strengths and weaknesses of TierDeveloper(in my opinion)

Strenghts
Easy to use. Learning curve is around 1 hour.
Customization of the generated code is possible through TemplateIDE tool provided with it.
Advanced features like synchronization with the database, automatic creation of relationships, inheritance support, object binding support etc.
Very responsive support staff
Support for large number of databases
Include your own business logic through use of Custom Hooks
Import Objects from Assembly and XML File
Support for webservices
Generates fully working database applications for real-life use

Weaknesses
Documentation is not very detailed.
MySQL and Postgres support is missing.

[AlisterCambell]

Here is a general checklist that one should consider while selecting an ORM product:

•Architecture of the Product.
•Support for relevant standards.
•Support for transactions.
•Handling of null values.
•Multi-DBMS support.
•Stored procedures.
•OO-Query syntax.
•Caching.
•SQL Logging.
•Data-binding.
•Customization of the generated code.

[Abritain]

Here is a general checklist that one should consider while selecting an ORM product:

•Architecture of the Product.
•Support for relevant standards.
•Support for transactions.
•Handling of null values.
•Multi-DBMS support.
•Stored procedures.
•OO-Query syntax.
•Caching.
•SQL Logging.
•Data-binding.
•Customization of the generated code.

All that is a strong order but i have managed to cover most with Zforce which can be see at http://www.zforce.co.uk/ and will be taking on board what you have said.

Regards