ORM makes your App DB-independent. Stored procs make your DB app-independent.
If you have multiple apps platforms all needing to use the same data logic in a common DB that won't change, it makes sense to use stored procedures. If you have an app that you need to deploy out in the wild against multiple database platforms, ORM is a sensible choice. It sounds like your case is the former. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 7 August 2010 22:51, Matthew Allen <a.matthe...@yahoo.com> wrote: > > This is rather annoying, the software development manager of the company I > work for decreed yesterday that all (I mean ALL) web application we write in > house from yesterday on, must now all be stored proc. No more inline-SQL and > no more ORM because of one badly written ORM by a member of the team. > > He has one valid reason in that we have one or two (not the majority of) > applications having the need to access data from different platforms (.NET, > PHP and CF). > > Does he really have a solid argument when he said that ORM compared to Stored > Proc and inline SQL is really in-efficient? In his previous life he was a > DBA, is he stuck in the past? or am I paranoid to think that he is only > keeping his options open, options open in the sense that, strategically, he > does not want to be tied to CF or is it really true that ORM's despite its' > obvious advantages is not great compared to stored proc? > > Thanks > > Matt > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
