Dear CFC experts, In order to save a BO in my app, I need to update several tables in my DB as there are PK/FK dependences. Transaction is needed, but Where to do it, and How to do it?
I use Illudium Code Generator, so every table has its own DAO/Gateway/Service. *Where?* 1.) at a custom method in the parent table's DAO 2.) at a custom method in BO's Service layer *How?* 1.) call a store procedure, and let the DBMS handle the transaction 2.) write TSQL (in my case, Ms-sql) inside cfquery 2.) use cftransaction, (performance hit is quite large)? And lastly, how would ORM fit into the picture? How would Transfer, for example, help me at this situation? Thank you, Henry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
