3 ms·
> When I'm joining multiple tables and looking for specific rows/objects that match multiple restrictions, ORM turns into a migrane of epic proportions. Perhap
by gnaritas 14y ago
> When I'm joining multiple tables and looking for specific rows/objects that match multiple restrictions, ORM turns into a migrane of epic proportions.
Perhaps you're doing it wrong. Put the complex query in a proc or view, and use the ORM to map the result set into memory. Using an ORM doesn't mean not using SQL when it works better.
- y0ghur7_xxx 14y ago>> When I'm joining multiple tables and looking for specific >> rows/objects that match multiple restrictions, ORM turns into a >> migrane of epic proportions. > > Perhaps you're doing it wrong. Put the complex query in a proc or > view, and use the ORM to map the result set into memory. Using an ORM > doesn't mean not using SQL when it works better. that's what he sad: use sql when it works better. if you put it in a proc, a view or your application makes no difference.