General information
Category:
The Mere Mortals Framework
Title:
Bizobjs and data updates
I'm using BizObjs and BizRules objects when performing any updates to a table. However, what about situations when your updating specified fields for sets of records in SQL tables?
My real world example is stock splits. I have to adjust the price along with a number of other fields in an SQL table by the split factor. My business rules are mirrored in both the business rules object and as SQL constraints.
I'm thinking I should just run a T-SQL statement from a method within my BizObj such as : UPDATE MyTable SET Price=Price/Split WHERE Ticker = 'ABC'
It would be so much faster, and so much less network traffic then retreiving and processing each record through my BizRules object.
How do you handle these situations?
TIA,
Anthony
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only