Auto-Generating Wrapper Classes for Stored Procedures
This is an interesting read on writing wrapper classes for sprocs:
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dndotnet/html/autousa2.asp
I am not using it, but I may in the future.