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:257930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
