MSDN Solution Architecture Center: Stored Procedure Object Interface Layer

MSDN Solution Architecture Center: Stored Procedure Object Interface Layer: "A stored procedure is a T-SQL program that executes on SQL Server and returns parameter values and/or a ResultSet. Business rules are often encoded in stored procedures, so many applications involve calling stored procedures and processing the data they return. Invoking Stored Procedures in ADO.NET requires a lot of code for each instance. It also causes the developer to switch from an OO paradigm into a functional paradigm with relational data. This is time-consuming and error-prone. Instead, SPOIL creates an OO layer of abstraction between the application and the database. At the highest level, SPOIL creates an object abstraction exposing a stored procedure as methods on managed classes."