Thanks Terrance, I've not seen Squidhead before, but if it's as good as it sounds then It would be perfect for me, anything to avoid writing DAO code ;-)
I'll have a look at it this afternoon, but it sounds fantastic, Rob -----Original Message----- From: Ryan, Terrence [mailto:[EMAIL PROTECTED] Sent: 04 June 2007 14:32 To: CF-Talk Subject: RE: Choosing an ORM I'm not going to jump in to Reactor vs Transfer. They're both great products. I wish I could use them. (We have a mandate for stored procs. ) But if you're looking to handle stored procedures, may I make a plug for my product, Squidhead (http://squidhead.riaforge.org/). It doesn't have hooks for any of the other frameworks yet, but it does implement the DAO and Gateway for a MSSQL database using stored procedures. And while it doesn't have any hooks for the frameworks, there's nothing to stop it from working with modelglue, or fusebox. In addition to writing its own CRUD in stored procs, it also reads in and makes available your stored procedures as CFC methods. It can handle multiple queries proc call, etc. Terrence Ryan Senior Systems Programmer Wharton Computing and Information Technology      E-mail:        [EMAIL PROTECTED] -----Original Message----- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Monday, June 04, 2007 4:06 AM To: CF-Talk Subject: Choosing an ORM Hello Guys, I've just started work on a large scale rebuild of my core business application, and to aid me the gruelling task I'm toying with implementing MG, ColdSpring and one of the ORM's. I've done some small work with these in the past but used Reactor. Now, I'm sure I've read somewhere that Reactor and MG got a divorce, and that MG would most likely end up sleeping with Transfer, is this the case? Another thing to take into consideration is that I had planned to take all my queries and move them into stored procs on my SQL Server as some of them were getting pretty fat and needed a helping hand to keep performance where I want it, will I still be able to do this when working with an ORM? What are your thoughts on this stuff? What's hot? And what's not? Look forward to hearing from you guys, Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
