Re: Search for ORM with Multi-Table-Object Support

Multi-Table-Mapping-Objects;I need are objects consisting out of more than just one table. Joined together as needed but transparent for the application.

This is a scenario for a view.You can also have a view that supports updates/DML on the underlying tables thjrough the view;for example check Oracle's materilized view

Using it maybe there is no need for an ORM

Comment on Re: Search for ORM with Multi-Table-Object Support

Replies are listed 'Best First'.
Re^2: Search for ORM with Multi-Table-Object Support by Xel (Novice) on May 03, 2012 at 06:21 UTC
I am sorry, but I can not use views. They can be updatable - yes. But they are (in MySQL which we are using) not insertable (reffering to Multi-Table-Views, whenever you want to insert into more than one table at once) There are just to many restrictions to be able to build a seperation-layer with views. I would really wish I could just use them and change nothing at the application at all. But they only do half the job.	[reply]

Replies are listed 'Best First'.

Re^2: Search for ORM with Multi-Table-Object Support
by Xel (Novice) on May 03, 2012 at 06:21 UTC

I am sorry, but I can not use views. They can be updatable - yes. But they are (in MySQL which we are using) not insertable (reffering to Multi-Table-Views, whenever you want to insert into more than one table at once)

There are just to many restrictions to be able to build a seperation-layer with views.

I would really wish I could just use them and change nothing at the application at all. But they only do half the job.

[reply]