/// Wednesday, March 29
MSDN: Stored Procedure Object Interface Layer
MSDN has an article on a stored procedure data layer using attributes.
As usual, the open source community has been doing this sort of thing for a while—iBATIS. It can handle both stored procedures and straight SQL. iBATIS is much more flexible. There are some codegen tools that will do the mappings for you.