I have a really specific need. The previous version of the applicaton that I was working on had a flat file based persistence layer, which was appropriate for the scope at that point. However, the next version, needs to have RDBMS persistence.

Now, the DB schema is a quite different from the current object model. We dont want to do a significant rewrite to try and make the object model similar to the data model.

What we would ideally want to do is try and map the existing object model to the data model in the database.
And there are significant differences betwen the two models and multiple joins and multiple table updates would be needed for any operation on a single object in the current object model.

What would be a good open source framework for doing this ?

Or should I be writing my own OR mapping functionality ?


Would it be a better idea to scrap the curent object model , and do a major rewrite ?

Any suggestions/critiques would be fabulous.

-Shameek

I did not use any O/R mapper product in my project. But I just came across SimpleORM. Looks like the author has good knowledge, knowing the issues, and provide something to deal with it in a simple way. Please see http://www.simpleorm.org/.