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