In my opinion most mature/complex client/server or n-tier applications
using SQL Server, Oracle, or MySQL, use stored procedures.
Without support (except by use of the execute method) for Stored
Procedures, Ruby on Rails or MonoRail is a Show Stopper. We are unable
to effectively use Ruby On Rails as all access to the db is using Stored
This does not mean that we are unable to use ORM. In fact, if we were to
be able to consider a Store Procedure results set as a View, we can
easily analyze the view (or DataSet) returned as a first step in
creating/updating the objects and their classes.
As to ActiveRecord, and ActiveRecord is not a proper representation of a
Busines Object. I think the patten is simplistic and although useful, it
is not sufficient. In my opinion we should have Busines Object
Collections and Business Objects. To create a Business Object Collection
we sould need to interate through the ActiveRecords.
I’d appreciate any comments, pleas to