All stored procs in one cfc? IMHO, that pretty ham-handed. CodeSmith generates a data layer (.NET) that is pretty spiffy and cfcpowertools (http://cfcpowertools.com/) does an awesome job at genning damn near the entire backend.
Warmest Regards, Phillip B. Holmes http://phillipholmes.com -----Original Message----- From: Jeff Fleitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 24, 2006 8:23 PM To: CF-Talk Subject: Re: All Stored Procs in 1 CFC? If you are using Windows and SQL Server, Plum will do this for you. The IDE (code gen) contains options for generating CRUD SPs per table and will also generate a CFC that calls them. I haven't been using SPs as of late, but it worked well with MS SQL 2000. I would think they would work with MS SQL 2005, but can't say for sure. http://www.productivityenhancement.com/plum/ HTH On 10/24/06, Brian Peddle <[EMAIL PROTECTED]> wrote: > > I have worked a few companies where they use .NET and know of several > other companies who follow this process. They have a generator that > reads all the stored procs and creates the needed code in .NET to make > the calls to the stored procedures in classes. All this is done > automatically and the file is never edited by human hands. One of the > cool things is that if a stored proc is altered and the file is > recreated on build any page calling that class will fail and they can > quickly and easily see what needs to be fixed. The other cool thing > is all the SQL is in one place. > > Anyway, has anyone ever done this in CF? Not so much the auto > generate stuff (although be good to know) but have one monster .cfc > with all the calls. Since it isn't compiled like .NET performance may > be a huge issue but not sure. Or maybe if this is tossed in > application scope it would fly. > > Thoughts? > > Hope this made sense. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
