Which is the best practice for Business Rules
a. Hardcoded Column Names
b. Rowwise values RuleName, Criteria
Please suggest the best method
That depends upon your implementation of the Business Rules, there is no rule of thumb for it. Do you implement the rules in the logic of SQL Server or your middle-tier ? Which approach did you use to validate the rules ?Jens K. Suessmeyer
http://www.sqlserver2005.de
|||we implement the rules in the middle tier
|||
It always better to use the Business Rules on the Middle Tier. That’s what all the Middle Tier apps says, don't use your middle tier as a wrapper of your SP, get the data and do it on middle tier.
It might be very easy to maintain & easy to implement. You can utilize all the language features while do this. But, DB sometimes you have to stay on the fixed boundary & limitations.
No comments:
Post a Comment