I may have asked this question before, so please excuse my encroaching senility :-). I have used both remote views and SQL Pass Through for data access in Mere Mortals, but I am wondering if the framework easily handles stored procedures for this.
It seems to me that using stored procedures to access data is less maintenance than using both stored procedures and business objects. In other words, I would like to write one sproc, ex. usp_GetCompanyList, and have that be the only way to get the list of companies. Then, in my business objects, make a SQL Pass Through call to uspGetCompanyList, rather than implementing "SELECT CompanyID, Name, City" etc. in the business object.
The reason for this is that if the structure of the Company table changes, I only have to make the change in one place, the sproc, rather than both the sproc and the business object. I realize that in an ideal world, everyone would be using my business object, but I am not so lucky :-).
Chris McCandless
Red Sky Software