Friday, August 10, 2007

SPOIL yourself!

SPOIL = Stored Procedure Object Interface Layer.

There has been many attempt by Microsoft and others to reduce the work of the developer and emphasis the concept of Rapid Application Development. I guess the intention is lesser you let the developer to code, lesser is the bug count.

SPOIL helps us to build a object oriented layer over database. Idea is that developer might never have to write ADO.Net to interact with their database. Say the stored procedure will become a object and will be strongly .net typed, thus reducing the coding effort and runtime errors. So, application would setting the values of the SP by properties.

Without SPOIL, it would be like shifting from the OO paradigm to functional, to call the SP and handle the output. It would involve writing length and error prone code.

But this did not really catch the attention of industry.