I am having problems keeping my Stored Procedures in sync with my Business Objects. For example, I have a "Loan" business object that contains data from multiple tables joined in a Stored Proc. Now, when I have to create multiple Stored Procedures to return the same structure (Loan By ID, Loan By Last Name, All Loans) I have to replicate that same joining logic. Now, say in 6 months the user wants me to add another field to the Business Object - that means I have to update my business objects and find all of the matching Stored Procedures. What a pain.

My new wild idea is to create views that map directly to my business objects. Every matching Stored Procedure would Select * from that view and then add it's individual criteria.

Tell me if that's a good or bad idea. I know that Select * is generally frowned upon, but I think the advantages of doing it this way exceed that concern. Is there a better way to do this? Somebody stop the insanity!