Check this out - Stored Procedure Object Interface Layer (SPOIL). It’s a really nice framework to use when working with Stored Procedures. It helps you map stored procedures directly to methods in .NET applications.